Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can you do dynamic churn analysis in Qlikview?

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.

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

May be like attached?

View solution in original post

9 Replies
satishkurra
Specialist II
Specialist II

Have you tried using the Adhoc reporting for this?

Not applicable
Author

I have not, could you provide an example? I think the most difficult part will be getting the churn type dimension.

satishkurra
Specialist II
Specialist II

PFA

In Whats New in QlikView 11 document, Please refer Reports Tab

Not applicable
Author

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.

Not applicable
Author

Anyone have other ideas?

settu_periasamy
Master III
Master III

May be like attached?

Not applicable
Author

This is exactly what I'm looking for. Thank you so much.

Not applicable
Author

@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?

settu_periasamy
Master III
Master III

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.