4 Replies Latest reply: Mar 22, 2013 11:06 AM by Nitesh Srivastava RSS

    Transaction No. in a Table

    Nitesh Srivastava

      Dear All,

       

      Need a small help... I have a table as Below

       

      DateACCNo.
      3/22/2013123
      3/22/20131
      3/22/20132
      3/23/2013123
      3/23/2013125
      3/23/2013127
      3/23/20131
      3/23/2013126
      3/25/2013123
      3/25/2013124
      3/25/20132
      3/25/20133
      3/30/20133
      3/30/2013124

       

      I want the output as below...

       

      Create DateMobile No.Transaction#
      3/22/20131231
      3/22/201311
      3/22/201321
      3/23/20131232
      3/23/20131251
      3/23/20131271
      3/23/201312
      3/23/20131261
      3/25/20131233
      3/25/20131241
      3/25/201322
      3/25/201331
      3/30/201332
      3/30/20131242

       

      I can get this Information whith the help of below formula in excel....

       

      =COUNTIF($B$2:B3,B3)

       

      please help if can can do the same in Qlikview.

       

      Thanks in advance...

       

      Regards,

      Nitesh Srivastava