topic Top 5 Accounts in QlikView

Top 5 Accounts

dandaanilreddy — Wed, 24 Aug 2016 18:58:26 GMT

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

Re: Top 5 Accounts

Wed, 24 Aug 2016 20:04:33 GMT

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

Re: Top 5 Accounts

sunny_talwar — Wed, 24 Aug 2016 20:05:04 GMT

The attached application is without any data

Re: Top 5 Accounts

dandaanilreddy — Wed, 24 Aug 2016 20:09:01 GMT

Please find the image below.

Re: Top 5 Accounts

sunny_talwar — Wed, 24 Aug 2016 20:44:34 GMT

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

Re: Top 5 Accounts

dandaanilreddy — Wed, 24 Aug 2016 20:51:00 GMT

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