Vote for your favorite Qlik product ideas and add your own suggestions.
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.
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-...
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...
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
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..
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.
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];
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.