1 Reply Latest reply: Apr 9, 2018 8:26 AM by Miguel Cunha RSS

    Qlik Sense- Top 10 Rank based on multiple Metrics

    Miguel Cunha

      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