3 Replies Latest reply: Nov 23, 2016 2:47 AM by Jorge Planas RSS

    Creating a retention table in qlik sense

    Vinol Dsouza

      Hi,

       

      I am trying to make a retention table in qlik sense and I am failing at it with multiple attempts.It would be great if someone could use the attached data and send me a QVF to solve this problem

       

      mto kha isaaclin chooco_co

       

      Output (which i want):-

      The table says for example 10000 users came in Jan16, out of this 7530 came back in Feb and out of 10K 9K came back in Mar. Basically the numbers on the right are subset of the leftmost number

       

        Note the numbers below are not exact and just a sample output

      RetentionJan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16
      Jan-1610,0007,5309,0005,3067826,9587,1133,464
      Feb-169,0004111,6547,3795,7824,2107,634
      Mar-168,0002,3604,9313,7981023,435
      Apr-168,8004,6562,2341,3394,235
      May-169,0008,7751,5885,244
      Jun-164,5002162,008
      Jul-167,700747
      Aug-162,232

      Data Available:-

      The data is in the form of date and user_id (attached is the excel)

       

      Pasted image at 2016_09_15 09_44 AM.png