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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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