7 Replies Latest reply: Jan 8, 2016 3:07 AM by ben lim RSS

    Cohort Analysis

    ben lim

      Hi Guys,

       

      I am trying to do a cohort analysis in Qlikview. I am getting the numbers but the placement of the data are wrong.

       

      Dimension (201510) refers to the joined date of the new customers. 0 1 2 3 are based on YYYYMM (Current Year Month) to determine. However I would like 0 (expression) to take reference of the YYYYMM from Cohort first YYYYMM data. Meaning 0 in 201510 refers to 201510 and 1 refers to 201511 in YYYYMM. But in 201511 , 0 refers to 201511 and 1 refers to 201512.

       

      Is this achievable through dimensionality.    

       

       

      Cohort_First_YYYYMM0123
      20151021031
      20151117970
      2015121239900
      201601133000