Showing Top 10 Model

[#1]

Hi,

I would like to create a summary table in Qlikview which shows top 10 printer models by quantity sold in the market. I can create it with one dimension, however when I am trying to add multiple dimensions, it doesn't seem correct. Attached is the excel data and output I am looking for. Any guidance or clue would be highly appreciated.

Simky

[Gysbert_Wassenaar · Accepted solution]

See attached qvw for three solutions.

[#3]

did you try sorting in descending order and the presentation tab > max number set to 10

[hic]

If you use

     =Aggr(If(Rank(Sum(Units))<=10,Only([MODEL NPD])),[MODEL NPD])

as calculated dimension, I think you will get what you want. You may want to suppress NULLs in the dimension, though.

HIC

[maxgro]

an useful Qlik doc on show top

Show Top Performers

[#6]

Hi Gysbert,

Thanks for the solution.

How can I calculate Unit Share % in for top 10 models only?

The below expression gives values for all models

sum(UNITS)/sum(TOTAL(UNITS))

[#7]

Go it .I am using relative option.