Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Experts
I have a following scenario,
I have a sales table by Branch
Now I want to chose Top 5 Customers By each Branch, By Sales
Please Help
Hi,
John Please use this expression used below.
By Sales,
=IF(Aggr(Rank(Sales),Cust_ID)<=5,Sales)
By Branch,
=IF(Aggr(Rank(Branch),Cust_ID)<=5,Branch)
Thanks.
Hi,
You can use input box .
See attached qvw.
Hi,
yes we can use input box but in that case we have to use two input box one for sale and one for branch.
Hi
How Can I do this in Script Level
I got sales Tables by month wise for last one year
Please Suggest;
Please see the attached file
See this example
And this
expression-->=if(aggr(rank(sum(sales)<=5),sales,[optional])
See my blog on this subject:
Q-Tip #8 – Ranking the Unrankable | Natural Synergies
cheers,
Oleg Troyansky
www.masterssummit.com - take your QlikView skills to the next level!