Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ipauldur
Creator
Creator

Top 3 Region for each month in pivot table

Hi,

I have a requirement to display top 3 region for each month based on sales value. But i don't want to display sales value.

I suppose to get the below results on Pivot table for the region values(AA,BB,CC,DD,EE),

Category     Month     Jan     Feb     Mar   

    A                            AA     BB      EE

                                 EE              

                                 DD                       

 

   B                           DD    AA         BB

                                         EE

                                         DD

   C                          EE     CC         EE

                                                      DD

                                                      CC

Find the attached example QlikView file with sample data. Is it possible to achieve the same above on pivot?

Please let me know. Thanks in advance.

Regards,

Durai.

8 Replies
nirav_bhimani
Partner
Partner

Hi,

Try this In Region Dimension

If (AGGR (rank(sum(Sales)), Region) <=3 , Region )

Regards,

Nirav Bhimani

ipauldur
Creator
Creator
Author

HI,

Thanks for your reply,

I want to display top 3 region for each month and category.

There is no region on your expression? How top3 region will be displayed for each month?

Thanks.

Not applicable

Hi

use this expression in ur expression tab

if(rank(Sum(sales))<=3,region,Null())

ipauldur
Creator
Creator
Author

Sorry. Not working!!!.

Thanks.

nirav_bhimani
Partner
Partner

HI,

Please Find the atttachment.

Its Done.

Regards,

Nirav Bhimani

ipauldur
Creator
Creator
Author

Hi,

I don't want to display top3 sales value. But i want to display top3 Region name for each month based on sales values. Please look at my original post sample format.

Thanks.

nirav_bhimani
Partner
Partner

Hi,

Tell me one thing is there any expression after that??

Bcoz If I Dont put any expression then its doent show any record and If I put 1 in the expression then its shows the output as you want.

PFA,

Do let me know, whether you will add any expression or not?

Regards,

Nirav Bhimani

ipauldur
Creator
Creator
Author

Hi,

Thanks for the reply. There is no other expressions.

But i want to achieve the same format which is mentiones in original post. Month name should come on top (Horizontal). I don't want to display '1'.

Thanks.