topic Re: Make an expression to only includ 2016 data in QlikView

Make an expression to only includ 2016 data

Wed, 25 Nov 2020 16:16:04 GMT

Hi, Guys.

I want the Expression below to only include pledge donors that are recruited in 2016.

=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'}>}AKTORID_FS_LOPENR) / Count(DISTINCT AKTORID_FS_LOPENR)

The variabel is FadderskapOpprettetÅr and the year is as mentioned 2016

Best regards, Christian

Re: Make an expression to only includ 2016 data

avinashelite — Thu, 12 May 2016 13:38:35 GMT

You could add one more condition in the set analysis rite?

=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'},Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR) / Count(DISTINCT {<Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR)

Re: Make an expression to only includ 2016 data

Anonymous — Thu, 12 May 2016 13:42:09 GMT

=Count(DISTINCT{$<InnbetalingsStatus={'Har innbetalt'},Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR) /Count(DISTINCT {<Year_field={"='$(FadderskapOpprettetÅr )' "}>}AKTORID_FS_LOPENR)