Display dimension with Null() measure in Qlik Sense

[Anonymous]

Hi all,

I couldn't find an answer to this, only how to hide a dimension with zero or null value, but I need the opposite.

My problem is that I have a dataset which for some dates have no values in my category field.

In my expression I use sum(transaction) and in my table chart I show it by the dimension Category.

Category	Sum
Category1	100
Category2	-
Category3	300

If I choose i.e January 2018, I don't have any transactions  for lets say Category2. It is missing values.

But in my table chart I want to display all values for my category dimension, no matter if there are any corresponding values or not.

Like in the example table above I would like to still be able to see Category2.

I think we could do this in QlikView by display all values or something? But I can't figure out how to do this in Qlik Sense.

Grateful for all help!

Thanks,

Britt Karin

[Chanty4u]

by default it will show all the data right?

can you sample excel to work on it?

[OmarBenSalem]

try :

in ur measure:

if(len(trim(sum(measure))=0,0,sum(measure))

or

if(len(trim(sum(measure)&YourDim)=len(trim(YourDim)),0,sum(measure))

and under adds-on, check show zero values

[Anonymous]

Tried to make an simplified example of my data where category2 is missing values for january18.

[Anonymous]

Tried both of your examples but get the same result. As long as I have chosen a date, the category with no value for this data is excluded.