topic Re: Top 5 values in piviot table in QlikView

Top 5 values in piviot table

dandaanilreddy — Wed, 24 Aug 2016 19:45:18 GMT

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

Re: Top 5 values in piviot table

Anonymous — Thu, 25 Aug 2016 09:47:11 GMT

Hi Anil!
Unfortunately, the attached file is empty!

Try again, pls.

Elena

Re: Top 5 values in piviot table

Anil_Babu_Samineni — Thu, 25 Aug 2016 10:18:50 GMT

Perhaps this

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

Re: Top 5 values in piviot table

Karim_Khan — Thu, 25 Aug 2016 10:21:46 GMT

Hi Anil,

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

Re: Top 5 values in piviot table

agomes1971 — Thu, 25 Aug 2016 10:35:19 GMT

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

Re: Top 5 values in piviot table

beck_bakytbek — Thu, 25 Aug 2016 10:42:00 GMT

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

Re: Top 5 values in piviot table

ramchalla — Thu, 25 Aug 2016 10:42:40 GMT

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)

Re: Top 5 values in piviot table

dandaanilreddy — Thu, 25 Aug 2016 16:57:16 GMT

Hi Ram

Thanks for your help i wrote the expression.

Re: Top 5 values in piviot table

oknotsen — Thu, 25 Aug 2016 19:42:38 GMT

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 .