Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Select null values

simonaubert
Partner - Specialist II
Partner - Specialist II

Select null values

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.

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
Tags (3)
8 Comments
simonaubert
Partner - Specialist II
Partner - Specialist II

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
Partner - Contributor III
Partner - Contributor III

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
Partner - Specialist II
Partner - Specialist II

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
Partner - Specialist II
Partner - Specialist II

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

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

Status changed to: Open - Collecting Feedback
robert99
Specialist III
Specialist III

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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived