Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

miguelcunha
Contributor

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
miguelcunha
Contributor

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

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

1 Reply
miguelcunha
Contributor

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

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

Community Browser