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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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