Null values in a table

[Reuven12]

Hey all,

I wanna see in the table products that customers didn't take as well and I have a problem with Null values.

for example: 

if I will choose 2022 I still wanna see customer B and C even if they didn't take anything

or if I will choose Shoe I still wanna see customer c even though he never took it.

Basically, I want it will behave like zero.

How can I do this?

[Anil_Babu_Samineni · Accepted solution]

Since it is Qlik Sense you need to enable one option that Null values in data handling properties of the object

[Reuven12]

What do you mean? How can I do it?