Build a Churn Model

Anonymous — Wed, 14 Jun 2017 14:38:32 GMT

This is a conceptual question.

I have three fields SUBSCRIPTION START DATE and SUBSCRIPTION END DATE and SUBSCRIPTION AMOUNT

I want to be able to SUM the SUBSCRIPTION AMOUNT month by month to show churn.

My issue is that I cannot use the start or end date fields as my date column ... I feel like I need to make a new date. Also, I am not sure how to write the set analysis to evaluate between these two dates.

The set analysis below has worked for me, but I am not sure how to represent this OVER TIME that is now start or end date.

=sum({$< Won ={'1'},[Subscription End Date]={">=$(=Date(Today(),'MM/DD/YYYY'))"}>} [ARR-equivalent (converted)])

Any help is appreciated.

- dave

Re: Build a Churn Model

sunny_talwar — Wed, 14 Jun 2017 14:41:26 GMT

May be using While loop in script to create a date field from start and end date

Loops in the Script

Re: Build a Churn Model

Anonymous — Wed, 14 Jun 2017 14:42:42 GMT

Similar to Sunny's response.......

Creating Reference Dates for Intervals

topic Build a Churn Model in QlikView

Build a Churn Model

Re: Build a Churn Model

Re: Build a Churn Model