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