Re: How to achieve Dimension limit in QlikView9 - Qlik Community

Report Inappropriate Content · ‎2013-09-02

Hi All,

Can you please help me on achiving dimension limmit Functionality in QV9 since it is avaliable from QV 10 onwards only.

Ex:

Top 10 Customers whose Revenue sums up to 1M
Whose profit is above X% basen on slider input

Thanks in advance..

vikasmahajan · ‎2013-09-02

use can use RANK

Please find following expression & refer following link

http://community.qlik.com/message/295424#295424

if(rank(aggr(sum(Sales), Region, [Sales Person]))<=15,

aggr(sum(Sales), Region, [Sales Person]))

Hope this resolves your issues.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-09-03

Thanks Vikas for your help.

Can you please help me on filtering whose contribution is less than X%(5%) based on

slider /Input Box input.Also whose contribution sums up to top X%(50% over all contribution from Top customers).