Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: Can you do dynamic churn analysis in Qlikview?

May be like attached?

9 Replies
satishkurra
Valued Contributor II

Re: Can you do dynamic churn analysis in Qlikview?

Have you tried using the Adhoc reporting for this?

Not applicable

Re: Can you do dynamic churn analysis in Qlikview?

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

satishkurra
Valued Contributor II

Re: Can you do dynamic churn analysis in Qlikview?

PFA

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

Not applicable

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.

Not applicable

Re: Can you do dynamic churn analysis in Qlikview?

Anyone have other ideas?

Re: Can you do dynamic churn analysis in Qlikview?

May be like attached?

Not applicable

Re: Can you do dynamic churn analysis in Qlikview?

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

Not applicable

Re: Can you do dynamic churn analysis in Qlikview?

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

Re: Can you do dynamic churn analysis in Qlikview?

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.

Community Browser