pivote table top 5 Emp count, Location and department wise

[Qlik__Vinodh]

HI all,

I have Two dimensions in Pivote table  like Location,Depatment . In that i need Each and Every Location wise top 5 Department should be presented as dimension in pivote table.and what i need is top 5 Employees count is the Expression in pivote table.if any one having soluation pls help me.

    locations are there 20 and 50  Departments there .

     Output is need like this  and it  should be pivote table  pls help me.

Location	Department	Top 5(This is Expression) =count(Employeeid)
usa	sales	92
usa	accounts	75
usa	research	50
usa	it	40
usa	R&D	30
uk	accounts	150
uk	doctors	100
uk	associative	79
uk	sales	60
uk	R&D	40

[nirav_bhimani]

Hi c vr,

In the above qvd its working properly. If possible then send your qvw demo file.

Regards,

Nirav Bhimani