topic set anlysis - only include 2016 data in QlikView

set anlysis - only include 2016 data

Wed, 25 Nov 2020 16:16:04 GMT

Hi, guys.

I'm struggling with an Expression. I want the Expression below to only include Pledge donors recruited in 2016.

I want to calculate the share that has InnbetalingsStatus='Har innbetalt' in 2016 amongst all Pledge donors recruited in 2016 - FadderskapOpprettetÅr=2016.

Can you please help me out here?

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

Best regards

Christian

Re: set anlysis - only include 2016 data

sunny_talwar — Thu, 30 Jun 2016 11:07:11 GMT

May be this:

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

Re: set anlysis - only include 2016 data

Anonymous — Thu, 30 Jun 2016 11:11:41 GMT

Hello Christian,

are you sure that your Year Field ist 2016? 2016 should be in [] Brackets ([2016])

Maybe select 2016 over your Year Listbox so then your Expression should look like this:

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

/Count(DISTINCT AKTORID_FS_LOPENR)

If you want to make the Expression over the Variable, then it looks like:

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

/Count(DISTINCT {<2016={$(FadderskapOpprettetÅr )}>}AKTORID_FS_LOPENR)