topic Re: Set analysis - help in QlikView

Set analysis - help

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Does anyone know how to use the "if statement" correctly in the statement below?

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

I want to see the average contribution (sum of all payments - ([#ReskontroInnbetaltBeløp])*-1) of all donors that has made at least one payment (InnbetalingsStatus={'Har innbetalt').

Re: Set analysis - help

avinashelite — Mon, 07 Mar 2016 12:30:17 GMT

Did you not get the exact column details , could you please explain it with the sample data

Re: Set analysis - help

engishfaque — Tue, 08 Mar 2016 05:42:51 GMT

Dear Christian,

I think you are looking for listed below expressions, please check and use according to your requirements.

Expression 1:

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

Expression 2:

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

Expression 3:

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

Expression 4:

=if(Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'}>} AKTORID_FS_LOPENR) > 0, Sum([#ReskontroInnbetaltBeløp])) - 1

Kind regards,

Ishfaque Ahmed