Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to compute average length of donor relationship in days

Hi,

I want to find out how long an average length of a donor relationship is amongst donors that have attrited with at least one payment.

Expression/Variable name at least one payment:

Expression/variable name "attrited" =FadderskapStatus=Stoppdato

Expression/variable name "at least one payment" =InnbetalingsStatus=Har innbetalt

Expression/variable name "start date of donor relationship" == FadderSkapOpprettetDato

Expression/variable name "end date of donor relationship" = FadderSkapSluttDato

Can anyone help me out here?

Best regards,

Christian

1 Reply
Not applicable
Author

bump