Empty/null values in table

[danihs]

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?

[jaibau1993]

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]

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]

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

For example

PrepKey	LoadingTime
СН10-Y001-R03YY2	12
СН10-Y001-R03YY2	13
BE99-Y001-R03YY2	12
BE99-Y001-R03YY2	8

G.

[jaibau1993]

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

Jaime.