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
(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.
Re: Can you do dynamic churn analysis in Qlikview?
Ah, I think we have a misunderstanding.
I need the churn type and churn calculations to be dynamic but the chart will always look the same. So I don't need ad hoc reporting. What I need help with is getting the churn type and churn fields to be dynamically calculated within the table like in my original excel attachment.