9 Replies Latest reply: Apr 14, 2016 12:36 PM by Settu Periyasamy RSS

    Can you do dynamic churn analysis in Qlikview?

    Benny Lu

      Has anyone had to do dynamic churn analysis in Qlikview? I'm running into what seems like Qlikview limitations on dynamic calculations using the inter-record functions.

       

      Attached is some sample data and what I've started in Qlikview. I've tried using the inter-record functions but they do not seem to be flexible enough and only works on expression/measures but the churn type dimension will need to use some sort of workaround as well.

       

      The desired result is a table with year, month, and churn type as dimensions and churn as the expression/measure. The trick here is the churn type and measure needs to be dynamic (i.e. value changes depending on filters). This means we can't calculate the churn type and churn fields in the LOAD and needs to be done within the table.

       

      Dimension: Churn type definition

      New - first occurrence where quantity > 0

      Upsell - current quantity - previous quantity

      Lost - first occurrence where quantity = 0

       

      Expression/Measure: Churn

      (current quantity - previous quantity)

       

      In the desired results, would need the table to populate the "churn if not segmented by product" and when filtered on product Web, to populate "churn if not segmented by product" within the same table.

       

      Any help is much appreciated.