3 Replies Latest reply: Feb 18, 2016 6:37 PM by surfman joe RSS

    what is my bottom 5 stores have poor inventory among the top 20 stores in sales?

    surfman joe

      I am having a business scenario need show some values from a returned set in straight table. A typical question is, what is my bottom 5 stores have poor inventory among my top 20 stores in sales? I only need show these 5 stores names with two columns, one is inventory level, one is sales $ amt. What is the best way to solve it in Qlik Sense.

       

      I attached a sample excel, the expecting result should be as follows, Thanks.

       

         

      store namesalesinventory
      87716%
      282312%
      5172616%
      2276817%
      770318%