9 Replies Latest reply: Apr 26, 2012 11:19 AM by kirtikakkar RSS

Top 50 names as dimesion of pivot table

kirtikakkar

Hi All,

 

I need to have top 50 of one field say names in rows of a pivot table. In other words, a dimension of top 50 names must be calculated in the script.

Please suggest most efficient way to do this.

 

Also, do we have rank function in Qlikview?

 

Thanks,

Kirti