Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator III
Creator III

Re: How to display blank values?

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
Highlighted
Partner
Partner

Re: How to display blank values?

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

Highlighted
Creator III
Creator III

Re: How to display blank values?

I tried but it's not working

Highlighted
Partner
Partner

Re: How to display blank values?

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

Highlighted
Creator III
Creator III

Re: How to display blank values?

yes,but nothing happened

Highlighted
Partner
Partner

Re: How to display blank values?

what's your measure expression ?

please send a screenshot to understand more.

Highlighted
Creator III
Creator III

Re: How to display blank values?

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