4 Replies Latest reply: Mar 12, 2014 11:03 AM by SIVASUBRAMANIAN KNK RSS

    Count

                   IDTEST DATE
      113/01/2013
      214/01/2013
      315/01/2013
      416/01/2013
      517/01/2013
      618/01/2013
      719/01/2013
      820/01/2013
      921/01/2013
      1022/01/2013
      1123/01/2013
      113/01/2014
      315/01/2014
      416/01/2014
      517/01/2014
      719/01/2014
      921/01/2014

       

      The above table shows the ID and TestDate.

      I want to get the following result in qlikview

      1 time - how many test conducted (2,6,8,10,11)-So it should count 6

      2 time - how many test conducted (1,3,4,5,7,9)-So it should count 6

      3 time - how many test conducted

      .....

      .....

      Kindly help me in scripting and expression part .

       

      Thanks and Regards,

      Sivasu