Easy Question

[jadams123]

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, 

J

[jadams123]

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

Is there a better way to write the code?

[Somasundaram]

Check the Suppress Null value  property.

[Somasundaram · Accepted solution]

Use,

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

and suppress Null

[dplr-rn]

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