topic Re: NullAsValue not working in App Development

NullAsValue not working

ali_hijazi — Thu, 30 Jul 2020 09:43:53 GMT

Hello
I got a table that has column that contains null values (field name is called Matching)
Users want when they put this dimension in a Table to be able to select null values
however the below script doesn't seem to work
isn't supposed for the Matching when value is null to display NULL and users can filter on NULL?
Kindly advise

Re: NullAsValue not working

Kushal_Chawda — Thu, 30 Jul 2020 11:35:12 GMT

Are you loading data from QVD or other source?

Re: NullAsValue not working

ali_hijazi — Thu, 30 Jul 2020 11:50:45 GMT

Yes I'm loading data from a QVD file

Re: NullAsValue not working

Kushal_Chawda — Thu, 30 Jul 2020 12:08:06 GMT

There could be several cause for this

1) If your load is optimized. In optimized load Qlik does not perform row by row checking due to which Mapping of NULL value not possible using this approach. To solve this either you can follow different approach like manually provide condition using isnull function or simply apply where condition in load as Where 1=1 then this approach will work

2) If you already have unoptimized load and still this approach is not working then you need to check that your NULL values are actually NULL or having white spaces. If so you need to manually convert it to NULL using below condition

if(len(trim(Matching))=0,'NULL',Matching)

Re: NullAsValue not working

LeeRoyMalgas_ — Wed, 28 Feb 2024 18:46:46 GMT

Hi, @ali_hijazi , were you helped?

Re: NullAsValue not working

ali_hijazi — Thu, 29 Feb 2024 08:41:34 GMT

Honestly I cannot remember
the post was made back in 2020!!
I need to check; I will get back to you