Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense- Top 10 Rank based on multiple Metrics

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

1 Reply
Anonymous
Not applicable
Author

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