Discussion Board for collaboration related to QlikView App Development.
My issue is if i have limited data set for currenselected value than the ranking both top and bottom rank shows same values.
But if my ranking is smaller than the actual data then top and bottom works fine.
Can any one help please?
Attached sample example
Anyone know how to fix this issue?
That seems quite obvious. Otherwise, what would be your expected output?
Whats your problem exactly.? can you show in your sample your resualt?
=Aggr(if( rank(sum(Sales),4,0)<=5 ,Salesman),Salesman)
Top 5 analysis using Rank fuction