Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Average amount of payments done by a specific group - set analysis

Hi,

I want to find out the avarege amount of payments done by donors that has attrited and has made at least on payment.

 

Expression/variable name "attrited" =FadderskapStatus=Stoppdato

 

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

 

Expression/variable name "payment" =NumericCount (#ReskontroInnbetaltBeløp)

Can anyone help me out With a set analysis here?

Best regards,

Christian

Tags (1)
1 Reply
Not applicable

Re: Average amount of payments done by a specific group - set analysis

I tried this one, it does not work even when I don't include

the "at least one payment" =InnbetalingsStatus=Har innbetalt condition

=(Count({<InnbetalingsStatus={'Har innbetalt'}>} [Antall innbetalinger])) / NumericCount (#ReskontroInnbetaltBeløp)