Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
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).