Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
Can I see a fragment of the sourse data in tabular form?
Regards,
Andrey
Hi,
My data and report looks like that:
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