Any work around to select Null?

[#1]

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?

[awhitfield]

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

[tresesco]

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').

[its_anandrjs]

Hi,

You have to work on the NULL value handling.

Check this doc

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

Regards

Anand

[vardhancse]

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