topic Re: how to test blanc and null values in script in QlikView

how to test blanc and null values in script

doespirito — Fri, 07 Apr 2017 11:38:45 GMT

hi every body,

here is a qw file in witch i try to test blanc or null value :

if INSEE = blanc or null then CODE_DEP_ZMSD = 'HZ'

if CODE_CANTON blanc or null then CODE_CANTON ='9999'

i've tried ='', =' ', isnull but it doesn't work.

Have somebody an idea ?

Thank you very much in advance,

Arnault

subsidiary question : why chek box for CODE_DEP_ZMSD doesn't contain a blanc line ( like CODE_CANTON) while it contains blanc or null values.

sunny_talwar — Fri, 07 Apr 2017 11:40:38 GMT

May be try these

if (Len(Trim(INSEE)) = 0,'HZ',CODE_DEP_ZMSD) as CODE_DEP_ZMSDc,

if (Len(Trim(CODE_CANTON))=0,'9999',CODE_CANTON) as CODE_CANTONc,

doespirito — Fri, 07 Apr 2017 11:47:03 GMT

yes it works,

Thank you very much Sunny