If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
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:
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?
HI! Perhaps you have multiple values LoadingTime for some values PrepKey?
Can you share a sample of data that reproduces the problem?