Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlikdevelopers
I want to show top 5 clinics , regions, territories and areas. I wrote the expression but i am unable to get top 5 values its displaying more values. I have uploaded the qvw. Please help me.
Thanks
Anil
Hi Anil,
Try with the below code.
If(Aggr(rank(sum({<Pipe.days_remaining={"> (-1)"},Region_Group={"IVF","Direct"}>} Pipe.Total_Expected_Quantity),4),Area)<=5,Area)
Hi Anil!
Unfortunately, the attached file is empty!
Try again, pls.
Elena
Perhaps this
Aggr(If(Rank(Clinics) >=5), Clinics)
Hi Anil,
Youcan achive the same through Rank function mor showing largest values tick box in Straight table
Hi,
have a look at this
http://www.learnqlickview.com/a-qlikview-tip-how-to-display-top-n-and-bottom-n-values/
HTH
André Gomes
Hi Anil,
first of all: your attach is empty,
and to Show top values, you should use the calculated Dimension:
for instance: if(aggr(Rank(Sum(YourValue)), YourField) < =5, YourField,Null()) and in Settins for Selected Dimension check Option: Supress When Value is Null
i hope that helps
beck
Hi Anil,
Try with the below code.
If(Aggr(rank(sum({<Pipe.days_remaining={"> (-1)"},Region_Group={"IVF","Direct"}>} Pipe.Total_Expected_Quantity),4),Area)<=5,Area)
Hi Ram
Thanks for your help i wrote the expression.
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .