topic Finding Top n values in QlikView

Finding Top n values

Thu, 24 Mar 2011 13:34:46 GMT

Hi,

I need to show the Top n values based on the selection in the slider.

I have two dimension(Year and Product ) in Pivot table. I have to show the top n Product's Sales for each year.

I managed to get the top n values. But when I select a value in the slider, Total values(Partial Sum) are not showing the correct value.

Finding Top n values

Miguel_Angel_Baeyens — Thu, 24 Mar 2011 13:40:43 GMT

Hello,

Take a look at this thread and the attached application. The issues may appear when there are several excluding dimensions (on product may be the most sold in one year but not in the other...)

Hope that helps.

Finding Top n values

Thu, 24 Mar 2011 17:53:50 GMT

Had a similar issue once. Basically I just turned your expression into a dimension so only Prod_Names that fulfill the Top Slider requirement are returned. Then for the expression, you simply use sum(Sales).

Attached is my attempt.

Finding Top n values

Thu, 24 Mar 2011 18:22:00 GMT

Forgot you had a cyclical group. Attached is another attempt. Just adds two expressions to the cyclical group called Group2. Will make more sense when you see it.

Finding Top n values

llauses243 — Thu, 24 Mar 2011 21:15:18 GMT

Hi shans_bala,

Pls to correct error value on data .xls and try again (see image attached)

Good luck, Luis.