Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ce_gutierrez
Contributor III
Contributor III

Calculation of Permanence

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).

Tabla1.PNG

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,

3 Replies
Siva_Sankar
Master II
Master II

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

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

-Siva

ce_gutierrez
Contributor III
Contributor III
Author

Hi Siva Thx for your answer,

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

Best Regards!

swuehl
MVP
MVP

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.