topic Re: Customer Retention Challenge in QlikView

Customer Retention Challenge

ebc — Wed, 23 Sep 2015 00:49:37 GMT

Hi all,

I’ve been stumped trying to solve a complex set analysis expression. The basic description is that I am trying to compare a customer list during two different dates. I refer to them as Date and Lookback Date.

Attached is my attempt and below is an example

Date	Customer
Jan 2014	A
Feb 2014	A
Feb 2014	B
Jan 2015	A
Jan 2015	B
Feb 2015	B
Feb 2015	C

I’d like to start by creating a chart like this.

Date	#	Lookback Date	# LB	Added	Removed	Retained
Jan 2015	2	Jan 2014	1	1	0	1
Feb 2015	2	Feb 2014	2	1	1	1

Re: Customer Retention Challenge

settu_periasamy — Wed, 23 Sep 2015 02:58:44 GMT

Hi,

Do you want the text boxes value in the chart? Like this

if yes, PFA.

if not, could you please give bit detail and expected output..

Re: Customer Retention Challenge

petter — Wed, 23 Sep 2015 05:30:03 GMT

Have you had a look at the "Telecom Churn" demo application that is available at the demo site of Qlik? You can download the full QVW and study how CHURN (customer active/ceased retention) is solved in that.

Re: Customer Retention Challenge

ebc — Wed, 23 Sep 2015 18:59:55 GMT

This is absolutely on the right track.

The only missing component is that you only incorporate one lookback period (Mar-2014 compared to Mar-2015). I want to run all of those calculations against multiple lookback periods (like Jan-2014 through Dec-2014 compared to Jan-2015 through Dec-2015).

Re: Customer Retention Challenge

ebc — Wed, 23 Sep 2015 19:02:37 GMT

Excellent example, thank you!

I was asked to build a chart in this specific format but I think we should absolutely incorporate views seen in the Churn example.

Cheers!

-Eric

Re: Customer Retention Challenge

ebc — Sat, 26 Sep 2015 18:55:05 GMT

I got a hint to use discrete values in my set expressions by way of variables. Here is some progress in the right direction but the resulting values still appear to be incorrect in my Combo Chart and Flat Table compared to by text boxes.

Anyone else see what I'm missing?