topic Re: Set analysis question in QlikView

Set analysis question

Wed, 25 Nov 2020 16:16:04 GMT

= if(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'}>}AKTORID_FS_LOPENR) Avg([#ReskontroInnbetaltBeløp])*-1

Hi,

Why does not this Expression work?

I want to see the average payment (#reskontroinnbetaltbeløp) amongst donors that has made at least one payment (har innbetalt).

Re: Set analysis question

sunny_talwar — Mon, 07 Mar 2016 10:47:40 GMT

May be this:

Avg({<InnbetalingsStatus={'Har innbetalt'}>} [#ReskontroInnbetaltBeløp]) * -1

Re: Set analysis question

kaushiknsolanki — Mon, 07 Mar 2016 10:51:32 GMT

Hi,

its because If statement do not allow set analysis.

Set analysis should be used with aggregation functions.

correct expression will be.

Avg({<InnbetalingsStatus={'Har innbetalt'}>}AKTORID_FS_LOPENR)

Regards,

Kaushik Solanki

Re: Set analysis question

swuehl — Mon, 07 Mar 2016 11:09:30 GMT

Or maybe

=Avg({<AKTORID_FS_LOPENR = p({$<InnbetalingsStatus={'Har innbetalt'}>}) >} [#ReskontroInnbetaltBeløp])*-1