0 Replies Latest reply: May 2, 2018 2:57 AM by Dhaval Vyas RSS

    Expression for Cohort Analysis

    Dhaval Vyas

      Hi,

      As I am working on Cohort Analysis in QlikSense want output as Following Screen Shot can Anyone Help me Out for how to write expression for it..

       

      Member Join in April and Retained in April Only it should show in April Column

      Member Join in April but Retained in May it Should show in first row of May Column while if join in May and Retained in May only then it should show in second row of May column

      Member Join in April but Retained in June it Should show in first row of June Column while if join in May and Retained in June then it should show in second row of June column and if join in June and Retained in June only then it should show in Third row of June column...and so on...

       

      Thanks in Advanced...