top 10 count of emp in pivote

[Qlik__Vinodh]

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,

[neha_shirsath · Accepted solution]

Hi,

Please See the attachments. Hope it will help you.

Regards,

Neha

[Qlik__Vinodh]

Hi neha,

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

[neha_shirsath]

Hello c vr,

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

[Qlik__Vinodh]

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