topic Re: expression help in QlikView

expression help

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can anyone help highlight what the expression needs to be to count 'Information Refused', and 'Prefer not to say'. The below expression works individually (i.e Count (if (([Religion]) = 'Information Refused',[Client No])) ) but not when I try and put them together:

Count (if (([Religion]) = 'Information Refused', 'Prefer not to say',[Client No]))

The data is below so the result of the expression should be 596.

Appreciate any help on the expression.

Re: expression help

Gysbert_Wassenaar — Fri, 15 Apr 2016 07:07:31 GMT

Try Count (if ([Religion] = 'Information Refused' OR [Religion] 'Prefer not to say',[Client No]))

Or better yet use this: Count ({<[Religion] = {'Information Refused','Prefer not to say'}>} [Client No])

Re: expression help

tamilarasu — Fri, 15 Apr 2016 07:07:37 GMT

Try,

Count ({<[Religion] = {'Information Refused', 'Prefer not to say'}>}[Client No])

Re: expression help

Chanty4u — Fri, 15 Apr 2016 07:08:01 GMT

=Count (if{<([Religion] = {'Information Refused'}, or '{[Prefer not to say] }'>},[Client No]))

Re: expression help

Kushal_Chawda — Fri, 15 Apr 2016 07:09:26 GMT

Count (if (match([Religion], 'Information Refused', 'Prefer not to say'),[Client No]))

Re: expression help

Fri, 15 Apr 2016 07:39:03 GMT

We also need to calculate value present, which is all information on religion - 'Information Refused',' Prefer not to say' and 'NULL'. This is the existing expression which works but only currently brings through NULL:

Count (Religion) - Count (if (Religion= 'NULL',[Client No]))

How can expression be amended to bring through all 3 categories?

Re: expression help

Gysbert_Wassenaar — Fri, 15 Apr 2016 07:46:17 GMT

Just add it to the list: Count ({<[Religion] = {'Information Refused','Prefer not to say','NULL'}[Client No])