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