Problem with Line Charts and Bar charts!

[#1]

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!

[#2]

Since im a newbie regarding Qlikview, please tell me how to!

[#3]

Can't see how that should help sorry.. Still i want the yellow line to show zeros since there is no data there!

[rbecher]

At least you can see that there are no data points.

[#5]

Yes, but still it is very confussing for people looking at the graph...

There must be a solution to this problem?

[rbecher]

Could you post an example. Maybe you can use Aggr() or a 2nd dimension..

[#7]

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.

[#8]

NumericCount (date_from)

Is my expression.

[#9]

Try Like Below:

IF(IsNull(NumericCount (date_from)) , 0 , NumericCount (date_from))

Uncheck the Supress zero values in the Presenation tab

[#10]

Yep, this should do it.

[#11]

I have unchecked the Supress Zero, and used your expression.

Is does not work 😕 Still the yellow line is there.