Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 name | sales | inventory |
---|---|---|
8 | 771 | 6% |
2 | 823 | 12% |
51 | 726 | 16% |
22 | 768 | 17% |
7 | 703 | 18% |
Hi
find attached a .qvf app
in a staright table
Dimension Store_name with this mesure
if(aggr(rank(sum(sales)),[store name])<=20 ,[store name])
Limitation set to bottom 5
mesures :
% inventory :
sum({<[store name]={"=Rank(Aggr(sum(sales),[store name]))<=20"},[store name]*={"=-Rank(Aggr(sum(inventory),[store name]))<=5"}>} inventory)
sales :
aggr(nodistinct if(rank(sum(sales))<=20,sum(sales)),[store name])
it's sorting this :
Hope Attached application help See Bottom
Vikas
Hi
find attached a .qvf app
in a staright table
Dimension Store_name with this mesure
if(aggr(rank(sum(sales)),[store name])<=20 ,[store name])
Limitation set to bottom 5
mesures :
% inventory :
sum({<[store name]={"=Rank(Aggr(sum(sales),[store name]))<=20"},[store name]*={"=-Rank(Aggr(sum(inventory),[store name]))<=5"}>} inventory)
sales :
aggr(nodistinct if(rank(sum(sales))<=20,sum(sales)),[store name])
it's sorting this :
I am using sense, can not tell if the qvw works. Appreciated for your contribution and help.