Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning,
I have a little thing to ask this morning.
i have my Sales Report on Qlikview and i have 8 Branches and i want to get the HIGHEST SELLING PRODUCTS for a Day Across All my Branches.
Please any help will be appreciated.
Thank You
i want it to show only those Items. i.e the Highest Selling Items
Below is my Script:
Sum({<ITEM_DESCRIPTION1= {"=Rank(Sum(INVC_EXT_PRICE)) <= 11"}>}INVC_EXT_PRICE)
Is it showing more than 10 items? Is that what the issue is?
Yes its showing more than 10 items. i need it too show just the 10 Items
That is interesting, do you have a sample you can share? or few rows of raw data?
Preparing examples for Upload - Reduction and Data Scrambling
Hi Omotayo,
try this:
Sum(Aggr(Sum({<ITEM_DESCRIPTION1= {"=Rank(Sum(INVC_EXT_PRICE)) < 11"}>}INVC_EXT_PRICE),Store))
Regards!