4 Replies Latest reply: Jan 18, 2012 3:18 PM by klangley RSS

    Converting SQL script to Qlikview

      Can someone tell me how to convert the following T-SQL field into Qlikview Script?

       

      Row_Number() over (partition by SSN order by DisDay desc)

       

      This basically will assign a rank by SSN to assign a descending list of patient visits where the list will start over for each SSN.

       

      For example,

      SSN    Disday      Rank

      10         12/11        1

      10         11/11       2

      10          10/11       3

      20          11/11       1

      20          10/11       2

      30          11/11       1

      ...

       

       

      I've tried using the iterno() function but can't seem to completely grasp it.

       

      Thanks,

      Keith