Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

oseimuduame
Contributor II

Re: Highest Selling Product

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)

Re: Highest Selling Product

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

oseimuduame
Contributor II

Re: Highest Selling Product

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

Re: Highest Selling Product

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

manucamon
Valued Contributor III

Re: Highest Selling Product

Hi Omotayo,

try this:

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

Regards!