4 Replies Latest reply: Mar 6, 2018 1:02 AM by Vishnu Sreekumar RSS

    Calculate row number for groups

    Vishnu Sreekumar

      Hi All,


      I have the following table (only the fields in black) and in qlikview script, I want to stamp a value GROUP_ROWNO which lets me know the Nth occurrence of MPATID based on the ascending order of CREATEDT.




      Attaching the sample sheet. Can anyone help me to calculate this in (1) script side  (2) UI using set analysis



      Vishnu S