topic Re: Showing Top 10 Model in QlikView

Showing Top 10 Model

Mon, 05 May 2014 17:56:29 GMT

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

Re: Showing Top 10 Model

Gysbert_Wassenaar — Mon, 05 May 2014 18:13:54 GMT

See attached qvw for three solutions.

Re: Showing Top 10 Model

Mon, 05 May 2014 18:18:33 GMT

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

Re: Showing Top 10 Model

hic — Mon, 05 May 2014 18:19:06 GMT

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

Re: Showing Top 10 Model

maxgro — Mon, 05 May 2014 18:20:11 GMT

an useful Qlik doc on show top

Show Top Performers

Re: Showing Top 10 Model

Mon, 05 May 2014 19:59:51 GMT

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))

Re: Showing Top 10 Model

Mon, 05 May 2014 20:20:32 GMT

Go it .I am using relative option.