Customer continuity rate by dealer - Qlik Community

doganogulturk · ‎2017-03-17

Hi. I'm new to QlikView. I want to calculate a rate that includes Customer continuity rate by dealer: For example:

In 2015: 1.000

In 2016: 2.000

In 2016 (old, from 2015): 700

In 2016 (new, didn't come in 2015): 1.300

Continuity rate from 2015 to 2016: 700/1000 = %70

How can I calculate this rate for the all dealers?

Thank you!

ahaahaaha · ‎2017-03-17

Hi,

Can I see a fragment of the sourse data in tabular form?

Regards,

Andrey

doganogulturk · ‎2017-03-20

Hi,

My data and report looks like that:

ahaahaaha · ‎2017-03-20

Hi,

You can see the solution options in the attached QVW file. If the form of the report is important, which is not always the case, you will have to repeat it. And so all the necessary calculations are presented in the charts.

Regards,

Andrey