Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pie chart showing the percentage of male/female answered our questionnaire, but there are some null values for some purposes, I tried to filter in the calculation field:
if([c-i-hh_gender]= Null() ,null(),count(KEY))
It didn't work for me.
P.S. I'm using Qliksense.
If it is a Qlik Sense question, post it in the Qlik Sense area, not in Qlik Datamarket .
I moved the topic, so this time you can forget about the comment.
Try this:
Count({<KEY = {"=Len(Trim([c-i-hh_gender])) = 0"}>}KEY)
Just exclude Null values in dimension properties.
Hi Hanan,
Try this: if(count(KEY)=0,'',count(Key))
G.
Hi Ralf,
That works only in Sense, when you have values without connected dimension.
Man | Woman | -
10 | 10 | 5
You can with that filter out the -, 5 column.
G.
How else you can have nulls in a pie chart?
Hi Ralf,
Short example:
Man | Woman | Other
10 | 10 | -
A table (fact):
ID S Value
1 Man 5
2 Woman 6
3 Man 5
4 Woman 4
B table (dimension):
Man
Woman
Other
G.
Thanks All and Sunny
But the (right) expression Sum(Value) will never gets you NULL.