9 Replies Latest reply: Sep 21, 2011 9:30 PM by smic1983 RSS

    Query about Auto number

      Dear Frds,

      Am new to QlikView and I couldn't find any solution for below logic, if any one knows please help me

      The Logic is

      My Table is like this

       

      Line No. Item No. Other Data
      11000
      21001
      31000
      41000
      51001

       

      And My required table from above one is

       

      Line No. Item No. Other DataItm Serial No
      110001
      210011
      310002
      410003
      5         10011

       

      I know about AutoNumber syntax in Qlikview, it will give the result as the Unique number for sames data but my requirement is totally opposite way.

      Please help me to get solution for this.

       

      With Regards,

      Mike S.