topic Re: Help with Line Chart in QlikView

Help with Line Chart

Fri, 02 May 2014 08:08:26 GMT

Hi,

Can someone please explain how I acheive the following...

I have a two dimensional line chart{month offset, start month). I'm trying to track customer churn rate by month, so how long a customer stays before cancelling. All start months, start with a 0 month offset and each subsequent month I add one to the offset. Please see attached image.

I'd like to change the structure of the chart so I calculate the accumulated percentage drop each month for each start month rather than show the number. Ie, month_offset 0 = 0%, month_offset 1 = 5%, month_offset 2 = 8%, month_offset 3 =12%, etc.

Can anybody offer some advice?

Many thanks.

Warren

Re: Help with Line Chart

MK_QSL — Fri, 02 May 2014 08:13:38 GMT

Can you provide some sample data please?

Re: Help with Line Chart

SergeyMak — Fri, 02 May 2014 08:16:50 GMT

there is no image.

could you attache an application?

Re: Help with Line Chart

Fri, 02 May 2014 08:24:32 GMT

Thanks for your replies. I have attached application - thanks.

Re: Help with Line Chart

Fri, 02 May 2014 08:44:29 GMT

Have attached - Thanks Sergey.

Re: Re: Help with Line Chart

SergeyMak — Mon, 05 May 2014 03:13:51 GMT

Hi Warren,

You can use expression like below as values on data point

Count(DISTINCT {<status={0}>} cust_no)/Count(DISTINCT TOTAL <start_date> {<status={0}>} cust_no)

PFA

P.S.: I rewrote your expression using set analysis

Re: Re: Help with Line Chart

Mon, 05 May 2014 14:54:15 GMT

Many thanks Sergey. Much appreciated.

Re: Re: Help with Line Chart

SergeyMak — Tue, 06 May 2014 01:00:50 GMT

Hi Warren,

If you have a correct answer please select one to close the discussion.

Regards,

Sergey

Re: Help with Line Chart

Tue, 06 May 2014 08:00:44 GMT

Hi Sergey,

I've marked yours as helpful and set the question to assumed answered.

Do I need to do something more than that?

Sorry for the confusion.

Warren

Re: Help with Line Chart

SergeyMak — Tue, 06 May 2014 08:05:47 GMT

No worries, Worren.

As I know there is another button to select a correct answer. Unfortunately, I've never started the discussion and I don't know the interface. But you can see that some discussions are green - it means that the question is answered.

So it helps further users to find a solution if they have the same problem.

Regards,

Sergey

Re: Help with Line Chart

Tue, 06 May 2014 08:07:56 GMT

Oh ok - I'll try and track it down…

Cheers