Suggest an Idea

[simonaubert]

This is simply the second biggest source of frustration on Qlik : I cannot select null in a chart and the turnaround is a pure nightmare.

Why? You can explain Null is not a value (which is true, ok) but the other products (wink, wink) allow Null selection.

[simonaubert]

I was reading the help : it's complete but shows mainly the complexity of the thing :
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Visualizations/null-...

[bartdeboed]

There are two workarounds though...

1) this is for a single field in the load script: https://community.qlik.com/t5/QlikView-Scripting/How-to-replace-Null-by-a-string-value/td-p/455729

2) this is for all null values in the load script: https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...

[simonaubert]

Hello Bart,

As  mentioned in my previous comment, I would say that if we have to use workarounds, it means that the product can be improved with more user-friendly, intuitive and default solution. The idea behind Qlik Sense is the self-service analytics and this kind of behaviour makes it complicated.

Best regards,

Simon

[simonaubert]

Re.

The NullAsValue  solution cannot be used with QVD optimized load. If I break the QVD optimized load, my load goes from 8 minutes to an hour (I have several dozens of millions lines.. and resident load is freaking slow). Obviously, I cannot use that..

[Patric_Nordstrom]

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

[robert99]

Here's another workaround that I found recently to remove nulls (as opposed to missing)

I just put this at the end of the script as required. So the region code is held in a  data table. And some region codes are missing in the REGION table

Set OtherSymbol = +;
Concatenate (REGION)
LOAD * Inline [
RegionCode, RegionName,RegionRename
+, unassigned,Noentry
];

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.