topic Easy Question in QlikView

Easy Question

jadams123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts:

I am putting the following code in my dimensions and its sort of working:

=if(REGION<>'ZZ'AND
REGION<>'zz' AND
REGION<>'Dx'AND
REGION<>'Nx' AND
REGION<>'Not Assigned' AND
REGION<>'-',
REGION)

Problem with this code is that there is a NULL value or some value '-' that keeps on showing up. So what I see is :

ON
QC
WST
-

I only want to choose 'ON', 'QC', and 'WST' in my REGION and nothing else. Not even null values or any value.

Thanks,

Re: Easy Question

jadams123 — Tue, 26 Mar 2019 13:39:52 GMT

Also When I do 'Supress when Values are Null' it works.

Is there a better way to write the code?

Re: Easy Question

Somasundaram — Tue, 26 Mar 2019 13:41:40 GMT

Check the Suppress Null value property.

Re: Easy Question

Somasundaram — Tue, 26 Mar 2019 13:43:58 GMT

Use,

Match(REGION,' 'ON', 'QC', 'WST')

and suppress Null

Re: Easy Question

dplr-rn — Tue, 26 Mar 2019 14:25:42 GMT

I would set analysis rather than a calculated dimension. it gives better performance (wont matter much if data size is small but its the recommended practice)

just use {<REGION={'ON', 'QC', 'WST' }>} in your expression
or put your code in the load script as a flag column. and use that flag as part of set analysis