topic Re: Calculation of Permanence in QlikView

Calculation of Permanence

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Calculation of Permanence

Siva_Sankar — Wed, 04 Oct 2017 05:38:02 GMT

Are you trying to convert the excel formula into Qlikview equivalent formula?

If yes, may i know the formula that you are using?

-Siva

Re: Calculation of Permanence

Anonymous — Sat, 07 Oct 2017 04:28:20 GMT

Hi Siva Thx for your answer,

I want to reply the formulas and the vizualization if is possible.

Best Regards!

Re: Calculation of Permanence

swuehl — Sat, 07 Oct 2017 09:18:51 GMT

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.