#7 Upper dimension benchmark in Qlik Sense

Compare one selected value with entire Dimension result at differents levels

In this example, I select a product and compare its rating with Sub Category and Main Category total rating

The same color coding is used in the bar chart and scatter plot to easily compare values by category

❓ How to ❓

All start with this set analysis :

Avg({$<Sub_Category="$(=Only(Sub_Category))"},Product_Name=>} Ratings_out_of_5)

Find full recipe in, download QVF