Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I think i have a wierd problem! When i use Bar chart you can see that the Yellow does not have values for Feb -> Jul and that is right. But in the Line chart the yellow line does have values over these month which is incorrect.
Thanksfull for help!
Since im a newbie regarding Qlikview, please tell me how to!
Can't see how that should help sorry.. Still i want the yellow line to show zeros since there is no data there!
At least you can see that there are no data points.
Yes, but still it is very confussing for people looking at the graph...
There must be a solution to this problem?
Could you post an example. Maybe you can use Aggr() or a 2nd dimension..
What's your expression? If it's a simple sum, you could try something like:
=if( IsNull (sum( field ) ) ), 0, sum( Field ) )
That should put a zero everywhere there is no value.
NumericCount (date_from)
Is my expression.
Try Like Below:
IF(IsNull(NumericCount (date_from)) , 0 , NumericCount (date_from))
Uncheck the Supress zero values in the Presenation tab
Yep, this should do it.
I have unchecked the Supress Zero, and used your expression.
Is does not work 😕 Still the yellow line is there.