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]

What does the chart look like? Is it at zero during those middle months?

[#3]

Still as my first post, the line is connection between still known value and the latest value.

[#4]

Check my attached qvw and see if it helps.

[#5]

Sorry, I only got the Private licens so i cant open your file!

Anyone else got a input to this topic?

[amit_saini]

Hi Erik,

Just Enable the option Suppress When Value is Null Under Dimension Tab in properties of chart.

Thanks,

[#7]

That does not help! Still the line is there and does not dip down top zero!

[#8]

Try populating zero for july and uncheck Suppress zero values. The line chart will automatically get connected to zero for july month and you can visually find the difference. Line will not be upward, instead it will be like a V shape while crossing july alone.

[#9]

Im reading data from a ODBC connection, so i will be hard for me to populate zero for a month..

But there is no values, i guess NULL for Mar, Apr, May, Juni, Juli.

But still i want the line to dip to zero and no create a line between the last known value and the value in Aug.

Thanksfull for all the help and suggestions!

[#10]

What is your Yellow Data for JAN , FEB ,.... DEC ? . So that we will guide you in a better way.

[#11]