Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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').
Hi,
You have to work on the NULL value handling.
Check this doc
https://community.qlik.com/docs/DOC-3155
Regards
Anand
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