idea Select null values in Suggest an Idea

Select null values

simonaubert — Wed, 25 Nov 2020 15:12:24 GMT

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.

Re: Select null values

simonaubert — Wed, 03 Jul 2019 10:34:10 GMT

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-values-in-visualizations.htm

Re: Select null values

bartdeboed — Wed, 17 Jul 2019 07:03:22 GMT

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/ScriptRegularStatements/NullAsValue.htm

Re: Select null values

simonaubert — Wed, 17 Jul 2019 07:34:02 GMT

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: Select null values

simonaubert — Tue, 03 Sep 2019 08:44:24 GMT

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

Re: Select null values - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Tue, 04 Aug 2020 12:57:16 GMT

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

Re: Select null values

robert99 — Thu, 12 Nov 2020 09:24:21 GMT

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
];

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

Meghann_MacDonald — Wed, 02 Aug 2023 16:26:44 GMT

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.

Re: Select null values - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:26:45 GMT