Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends,
I need help to reply this excel report on Qlikview, maybe someone have the same need. This report seeks to identify the time with which the customer remains with the contracted service.
The First table:
Altas = New Sales
Bajas = Loss Sales
The first table is simple to work with. The new sales information by period is shown as well as the lost by period. Both amounts are subtracted and accumulated month by month. This accumulation I solved using As of Periods (Rolling To date).
My problem is for thi other tables that this report has. I'm Attaching the Excel Report with the formulas to do the differents calculations.
if someone has something similar or can give me an idea to reply this excel, i'll I appreciate it.
Best Regards,
Are you trying to convert the excel formula into Qlikview equivalent formula?
If yes, may i know the formula that you are using?
-Siva
Hi Siva Thx for your answer,
I want to reply the formulas and the vizualization if is possible.
Best Regards!
Try creating reference dates for your contracts, that is create a record per month the contract is valid.
It's explained in detail here
Creating Reference Dates for Intervals
and
Help regarding carryon count of tickets
Using the reference dates and maybe the concept of the AsOfMonth in addition should help you achieve what you required.