Fill in Missing Values

[Anonymous]

I've read a few posts, as well as the NULL and Nothing paper by Henric, but I'm still unable to achieve what I'd like to do.

Using Sense July 17 Patch 1, I have a table that shows some missing values. From what I've read, I should be able to use IsNull() to test for these, and hopefully fill in a default value. However, IsNull() seems to return null. This table shows an example:

Interestingly, if I unselect "Include null values" for the CP.Ven_Nbr field, the rows with missing values are excluded.

Would like to replace the hyphen with a default value.

Can someone point me in the right direction?

Thanks,

Mike

[lgutierrez]

Have you tried manage the null values from the extraction?

I normaly get data without null values from the sorce.

regards.

[rittermd]

Are you sure that the field is Null?

I would also agree with Lucio about doing this check in your script and loading the default value there.

[shraddha_g]

try len(CP.Ven_Nbr field)<2

If len(field) is giving you any values then you can apply if condition.

Else you can do this in Script by using Set NullasValue

refer NullAsValue ‒ Qlik Sense

[Anonymous]

Hi Lucio,

Yes, that could work, but I was curious about this behavior. It seems like I'm missing something and I'd like to understand what that is.

Regards,

Mike

[Anonymous]

Hi Mark,

I'm pretty sure it's null - it has the hyphen and grayed-out box, plus when unselect "Include null values", those rows are excluded.

Thanks,

Mike