Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
danihs
Contributor
Contributor

Empty/null values in table

Hi Qlik Sense experts,

I have a question regarding a table chart in Qlik Sense.

I have defined the NullAsValue variable and it works for one of the columns (TransitTime) but it doesn't work for the other two (LoadingTime, PickPackTime) even by using a formula (see below picture).

The table contains data from different script tables.

How could I do to see "Null" so be able to select them also in those 2 columns?

 

clipboard_image_0.png

Labels (1)
4 Replies
jaibau1993
Partner
Partner

Hi! maybe it is because those are not Null values but they are Missing Values, it is, there are no records related with those dimension values. 

Take a look to this post by HIC:

https://community.qlik.com/t5/QlikView-Documents/NULL-handling-in-QlikView/ta-p/1484472

danihs
Contributor
Contributor
Author

Hello, 

As you said it is probably a missing value.

Thanks for your answer but I didn't find a way to solve it.

In this link https://community.qlik.com/t5/Qlik-Design-Blog/Finding-NULL/ba-p/1474279 the discussion is around how to find Null or Missing values but in QlikView, but I am working in Qlik Sense...

Any other suggestion?

g_bolshakov
Contributor II
Contributor II

HI! Perhaps you have multiple values LoadingTime for some values PrepKey?

 

For example

PrepKeyLoadingTime
СН10-Y001-R03YY212
СН10-Y001-R03YY2 13
BE99-Y001-R03YY2 12
BE99-Y001-R03YY2 8

 

G.

jaibau1993
Partner
Partner

Can you share a sample of data that reproduces the problem?

Jaime.