Discussion board where members can get started with Qlik Sense.
I have some columns in the dimension.
In that dimension there some values along with the null values.
for example --
there is 5 country along with two bank values
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?
I tried this:-
In data load editior:-
If(len(Trim(Play_Active_Type))=0,1,Play_Active_Type) as flag
In expression :-
it's working fine.
View solution in original post
if you mean null values you have to check "Include null values" under dimension.
I tried but it's not working
did you also check the option "Include zero values" under Add-ons->Data handling ?
yes,but nothing happened
what's your measure expression ?
please send a screenshot to understand more.