Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner - Creator II
Partner - Creator II

top 10 count of emp in pivote

Dear all,

i have Emp table and,i need top 10 Emp count is required year,month and desigation wise in pivote table .if any one know the soluation pls help me.

Thanks,

1 Solution

Accepted Solutions
neha_shirsath
Specialist
Specialist

Hi,

Please See the attachments. Hope it will help you.

Regards,

Neha

View solution in original post

4 Replies
neha_shirsath
Specialist
Specialist

Hi,

Please See the attachments. Hope it will help you.

Regards,

Neha

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

Hi neha,

i need for empid count wise top 10 high values.please help me out this

neha_shirsath
Specialist
Specialist

Hello c vr,

Can you please create a demo structure for your output. So that it would be more clear.

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

year,location,desigation ,  Count(Empid)[Expression]

  2012,dd,dsddf,                    35

                                             20

                                             19

                                              12

                                               8

each and every location top 5 employees count value ,not a sum value.please help me out