Discussion board where members can get started with QlikView.
I am putting the following code in my dimensions and its sort of working:
=if(REGION<>'ZZ'ANDREGION<>'zz' ANDREGION<>'Dx'ANDREGION<>'Nx' ANDREGION<>'Not Assigned' ANDREGION<>'-',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 QCWST -
I only want to choose 'ON', 'QC', and 'WST' in my REGION and nothing else. Not even null values or any value.
Match(REGION,' 'ON', 'QC', 'WST')
and suppress Null
View solution in original post
Also When I do 'Supress when Values are Null' it works.
Is there a better way to write the code?
Check the Suppress Null value property.