Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
vanand3535
Contributor

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
Contributor

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.

6 Replies
agigliotti
Honored Contributor II

Re: How to display blank values?

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

vanand3535
Contributor

Re: How to display blank values?

I tried but it's not working

agigliotti
Honored Contributor II

Re: How to display blank values?

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

vanand3535
Contributor

Re: How to display blank values?

yes,but nothing happened

agigliotti
Honored Contributor II

Re: How to display blank values?

what's your measure expression ?

please send a screenshot to understand more.

vanand3535
Contributor

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.

Community Browser