Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be like attached?
Have you tried using the Adhoc reporting for this?
I have not, could you provide an example? I think the most difficult part will be getting the churn type dimension.
PFA
In Whats New in QlikView 11 document, Please refer Reports Tab
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.
Anyone have other ideas?
May be like attached?
This is exactly what I'm looking for. Thank you so much.
@settu_periasamy Do you have any suggestions on getting the New, Upsell, Lost as a Dimension so I can add subtotal or total to it?
Hi,
I tried it in some ways. sorry, not able to do it. May be you create other thread and ask.
You will get more response.