Skip to main content

Suggest an Idea

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

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

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