Solved: Show Top Ten In A Pivot Table - Qlik Community

Anonymous · ‎2011-09-23

Hi,

Is there any way where I acan show only the top ten values in a Pivot table. I used rank to calculate the top ten, but not able to show only those entries with rank <=10 , though it shows the rank but along with the 10 the rest is showing. Attached is the sample for that. PLIZ HELP

kaushiknsolanki · ‎2011-09-23

Hi,

This might be the what you want.

Have a look at the attached QVW.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

kaushiknsolanki · ‎2011-09-23

Hi,

This might be the what you want.

Have a look at the attached QVW.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anonymous · ‎2011-09-26

Thank you Kaushik.. It worked