Qlik Sense- Top 10 Rank based on multiple Metrics

[Anonymous]

Hey Guys,

I would like to know if it is possible to do a top 10 rank in a bar chart by the agreggation of all the measures.

Basically, I have a bart chart with 1 dimension (Dimension: Product) and 3 measures (Metrics: Sales North; Sales Center, Sales South)

I wanted the measures to be in % so each measure is calculated as:

sum({$<Date_year={'2018'}, Store_ZoneCC={'North'}> } Sales_Value) / sum({$<Date_year={'2018'}> } total Sales_Value)

When I set a fixed value for top 10 produtcs, the top 10 will be made based on the first measure.

What I need is to do the top 10 based on the total sales and not on one of the measures.

Can you help me with this?

Thanks in advance,
Miguel Cunha

[Anonymous · Accepted solution]

Guys,

solved it by adding the dimension "Store_ZoneCC" to the chart dimensions. And in the measure I deleted the Store_Zone_CC condition.

Worked fine.

Best Regards,
Miguel Cunha