2 Replies Latest reply: Dec 13, 2017 7:25 AM by vinayak lAKESHRI RSS

    How can convert date column into month and count of that month in the table

    vinayak lAKESHRI

      How can convert date column into month and count of that month in the table? In Qliksense

       

      Please find the attached excel for reference. and input and output details

       

      Input :                                                                                                 

       

         

      Client noDate_ADate_BDate_C
      112/7/20166/7/201712/7/2017
      21/7/20171/7/20171/7/2017
      32/7/20172/7/20172/7/2017
      43/7/20173/7/20173/7/2017
      54/7/20174/7/20174/7/2017
      65/7/20175/7/20175/7/2017
      76/7/20176/7/20176/7/2017
      87/7/20177/7/20177/7/2017
      98/7/20178/7/20178/7/2017
      109/7/20179/7/20179/7/2017
      1110/7/201710/7/201710/7/2017
      1211/7/201711/7/201711/7/2017
      1312/7/201712/7/2017

      12/7/2017


       

       

      Output:

       

         

      Client no123
      MonthDate_ADate_BDate_C
      Jan-17222
      Feb-17000
      Mar-17222
      Apr-17444
      May-17111
      Jun-17000
      Jul-17000
      Aug-17000
      Sep-17000
      Oct-17666
      Nov-17222
      Dec-17111