3 Replies Latest reply: Jul 6, 2017 5:22 AM by Sathyanath Lappasi RSS

    Cohort Analysis in Qlik Sense

    Sathyanath Lappasi

      Hi All,

      How to produce a Cohort Analysis that shows existing and new customers contribution to the business carried along YoY. Objectives listed below.

      1. Showcase year wise sales (in stacked bar graph) of existing and new customers by sales figures to see revenue contribution YoY.

      2. Same in percentage wise.


      Dimensions:

      Customer ID

      Order ID

      Order Date


      Measure:

      Sales ($)


      I need to achieve this in front-end without having to work on the back-end script as this analysis has to be done by a business user who is not familiar with Scripting. The dimensions will also keep changing and hence looking for simple functions and logic which will help the user to achieve the same.


      Version: Qlik Sense Desktop June 2017