Top 5 Accounts

[dandaanilreddy]

Hello Qlikdevelopers

I am trying to get top 5 clinical names , Areas regions and territories in the piviot table . i wrote the expression but i am not getting top 5 values. Can some one please help me.

Thanks

Anil

[#2]

There is no data in that.  Quick question though: Why are you using a pivot table?  Would it be easier to use a straight table and then just do dimension limits and top 5? Or Bottom 5? Or put your calculations in there?  I'm not sure how complex your calculations are without sample data, and maybe you can do your If statements on the back end-- If Region Group is IVF then whatever as Territory

[sunny_talwar]

The attached application is without any data

[dandaanilreddy]

Hi

Please find the image below.

[sunny_talwar]

What would I be able to do with an image my friend? I won't even be able to load this

[dandaanilreddy]

Hi

I cannot copy the data as the application has hidden script. I dont have authorization to copy the app. Please find the below expressions i wrote to get the top 5 values. i have 4 calculated dimensions and 2 expressions.

Dimesions:

1) = if(match(Region_Group,'IVF','Direct'),Area)

2) = if(match(Region_Group,'IVF','Direct'),if(aggr(rank(sum(if(Pipe.days_remaining>-1, Pipe.Total_Expected_Quantity))),Region)<=5,Region))

3) =if(match(Region_Group,'IVF','Direct'), Territory)

4) clinic_Name

The calculated dimension is displaying more than 5 values.

Thanks

Anil