Top 5 values in piviot table

[dandaanilreddy]

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

[Anonymous]

Hi Anil!
Unfortunately, the attached file is empty!

Try again, pls.

Elena

[Anil_Babu_Samineni]

Perhaps this

Aggr(If(Rank(Clinics) >=5), Clinics)

[Karim_Khan]

Hi Anil,

    Youcan achive the same through Rank function mor showing largest values tick box in Straight table

[agomes1971]

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

[beck_bakytbek]

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

[ramchalla · Accepted solution]

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)

[dandaanilreddy]

Hi Ram

Thanks for your help i wrote the expression.

[oknotsen]

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 .