Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

brittkarin
New Contributor II

Display dimension with Null() measure in Qlik Sense

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.

CategorySum
Category1100
Category2-
Category3300

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

4 Replies
sureshqv
Esteemed Contributor III

Re: Display dimension with Null() measure in Qlik Sense

by default it will show all the data right?

can you sample excel to work on it?

OmarBenSalem
Esteemed Contributor

Re: Display dimension with Null() measure in Qlik Sense

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

brittkarin
New Contributor II

Re: Display dimension with Null() measure in Qlik Sense

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

brittkarin
New Contributor II

Re: Display dimension with Null() measure in Qlik Sense

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.

Community Browser