Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
oseimuduame
Creator II
Creator II

Highest Selling Product

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

14 Replies
oseimuduame
Creator II
Creator II
Author

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)

sunny_talwar

Is it showing more than 10 items? Is that what the issue is?

oseimuduame
Creator II
Creator II
Author

Yes its showing more than 10 items. i need it too show just the 10 Items

sunny_talwar

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

Uploading a Sample

Anonymous
Not applicable

Hi Omotayo,

try this:

Sum(Aggr(Sum({<ITEM_DESCRIPTION1= {"=Rank(Sum(INVC_EXT_PRICE)) < 11"}>}INVC_EXT_PRICE),Store))

Regards!