Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Average customer lifetime

Good afternoon

     I am trying to calculate the mean lifetime of customers every month. I have a table where the discharge date and date low of each customer appears. I want to calculate the number of customers who are active each month and the number of days that have been active until this month, later to calculate the average.

     Excel attached an example of what I'm trying to do.

Many thanks for your time.

Community Browser