Qlik Sense- Top 10 Rank based on multiple Metrics

Anonymous — Wed, 04 Apr 2018 14:31:52 GMT

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

Re: Qlik Sense- Top 10 Rank based on multiple Metrics

Anonymous — Mon, 09 Apr 2018 12:26:01 GMT

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