Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vanand3535
Creator III
Creator III

How to display blank values?

I have some columns in the dimension.

In that dimension there some values along with the null values.

for example --

dimension ---country

there is  5 country along with two bank values

then

in the measure by expression i want to display total number of country as 7(5values+ two blank values) not 5 only

How can I display the blank values?

1 Solution

Accepted Solutions
vanand3535
Creator III
Creator III
Author

I tried this:-

In data load editior:-

If(len(Trim(Play_Active_Type))=0,1,Play_Active_Type) as flag

In expression :-

Flag={'1','unknown','other:specify'}

it's working fine.

View solution in original post

6 Replies
agigliotti
Partner - Champion
Partner - Champion

if you mean null values you have to check "Include null values" under dimension.

vanand3535
Creator III
Creator III
Author

I tried but it's not working

agigliotti
Partner - Champion
Partner - Champion

did you also check the option "Include zero values" under Add-ons->Data handling ?

vanand3535
Creator III
Creator III
Author

yes,but nothing happened

agigliotti
Partner - Champion
Partner - Champion

what's your measure expression ?

please send a screenshot to understand more.

vanand3535
Creator III
Creator III
Author

I tried this:-

In data load editior:-

If(len(Trim(Play_Active_Type))=0,1,Play_Active_Type) as flag

In expression :-

Flag={'1','unknown','other:specify'}

it's working fine.