top 5 values in pivote table expressions

[Qlik__Vinodh]

Dear all,

I have the dimensions like  Region,Location,desigation for this i need the top 5 counts.

if any one having soluation pls let me know

[#2]

hi

what's you want in top 5

[khadeer]

If u r using 11 version u have dimension limits tab, there u can select ur dimension on which u want to restrict,

u have differen options on that tab top, bottom, large.... like this

[nirav_bhimani]

Hi,

You can try this.

sum({<Customer={"=rank(sum(Sales))<=$(=vTop)"}>} Sales)

Where set vTop=5 in variable, so that it will give you correct result. In place of customer add ur dimension which u want.

Regards,

Nirav Bhimani

[Qlik__Vinodh]

top 5 Employee count

[Qlik__Vinodh]

top 5 employee

[Qlik__Vinodh]

hear i am having more dimensions in pivote table.......

[Qlik__Vinodh]

location and year wise top 5 Employee count  ...............required pls help me out this

[Qlik__Vinodh]

HI,

I need the Count of Employee-id is the top 1 values.

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

  2012,dd,dsddf,                    35

                                             20

                                             19

                                              12

                                               8

like wise i need for each and every year,Location and desigarion wise need yar .please help me out.

[nirav_bhimani]

HI,

Try this,

AGGR ( sum({<Customer={"=rank(sum(Sales))<=$(=vTop)"}>} Sales), year,location,desigation)

Regards,

Nirav Bhimani