Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
rkpatelqlikview
Creator III
Creator III

How to give the Rank Scenario

Hi All,

Please suggest on this.

There is Ranking system below is the scenario.

Exampe:

-> I have stores and I divided that store into 5 Groups

     (Group1 Store which is "<=5sales, Group2   "5 to 10 Sales"

     Group3 "10-20Sales", Group4 "20-52Sales" , Group5 "50above" sales)

->  There are 4 KPI's %.  I need to consider 25% from each KPI.

->  I need to give the rank for Store based on this 4KPI and sales from Each group. 

suppose - Group 1 is having 4 stores. If same KPI % it should compare with sales.

          Store   Sales   KPI%     Rank

           ABC       3         55%      3

           DEF       6         55%      2

           GHI        2         75%      1

            JKL       8         45%      4

If select any Store that rank should show  -> current Rank like this   1/ 4(Total stores). and previous Rank of that particular store  as well.

Please can any one help on this.

0 Replies