topic Re: Any work around to select Null? in QlikView

Any work around to select Null?

Wed, 25 Nov 2020 16:16:04 GMT

It looks like qlikview can only select data field. Null in sql (also '-' in qlikview) cannot be selected. It there a way to work around so that I can make the same selection just as that in sql --> 'where 'Business Unit C1' is null' in qlikview?

Re: Any work around to select Null?

awhitfield — Wed, 02 Nov 2016 11:22:55 GMT

HI Heok,

you could supply a default value in he load script, in your sql select

isnull("Business Unit C1", "Unknown") as ("Business Unit C1",

Andy

Re: Any work around to select Null?

tresB — Wed, 02 Nov 2016 12:00:40 GMT

One way (without making change in the script) could be like:

Assuming you have your first chart column 'Business Unit', you know that some of the

records lack 'Business UnitC1' against 'Business Unit', i.e. the 'Business UnitC1' is occasionally NULL. Then try like:

Step1:

First select all 'Business UnitC1' (right-click the 'Business UnitC1' and choose 'Select All').

Step2:

Then select the excluded 'Business Unit' (right-click the 'Business Unit' and choose 'Select Excluded').

Re: Any work around to select Null?

its_anandrjs — Thu, 03 Nov 2016 08:03:48 GMT

Hi,

You have to work on the NULL value handling.

Check this doc

https://community.qlik.com/docs/DOC-3155

Regards

Anand

Re: Any work around to select Null?

vardhancse — Thu, 03 Nov 2016 08:06:25 GMT

Hi,

Try to identify null() and convert to some text like Null.

so that all nulls will be converted to Null text and can be selected