This content has been marked as final.
Show 4 replies
-
Re: Display dimension with Null() measure in Qlik Sense
Chanty 4u Apr 3, 2018 5:10 AM (in response to Britt Karin Børnes )by default it will show all the data right?
can you sample excel to work on it?
-
Re: Display dimension with Null() measure in Qlik Sense
Britt Karin Børnes Apr 3, 2018 5:27 AM (in response to Chanty 4u)Tried to make an simplified example of my data where category2 is missing values for january18.
-
Example.xlsx 8.1 K
-
-
-
Re: Display dimension with Null() measure in Qlik Sense
omar bensalem Apr 3, 2018 5:16 AM (in response to Britt Karin Børnes )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
-
Re: Display dimension with Null() measure in Qlik Sense
Britt Karin Børnes Apr 3, 2018 5:30 AM (in response to omar bensalem )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.
-