SHOW NULL VALUE IN CHART

[#1]

I have a combo chart having one dimension and two expressions.

One expression i have used for refernce line and one expression for actual for the same dimension, but the problem is when the value for the actual is null it is suppressing the value of actual as well ,which is not desirable.

I have checked the "Show all values" but no luck.

Can anyone tell how to show all the values??

[rajni_batra]

Uncheck Supress Null Values and Missing Values From Dimension and Presentation Tab.

Hope this Helps!!

[#3]

Thanks Rajni , your answer partly resolved the problem, but still there some left.

Picture 1 shows before scenario(Supress Zero Values)

Picture 2 shows unchecked Supress zero values

however there is value 20 for actual in data

[rajni_batra]

Can u share this in Demo app with the scenario u want??

It woud be easy to understand

[#5]

This is showing strange behaviour, when i tried to recreate with sample data, its showing the correct picture, however the object properties are same.

Can u explain this.

[senpradip007]

Hi sidrahasan,

Unchecked Suppress Null Value and Suppress Missing in the chart property under Dimenssions and Presentation Tab.

Cheers

PRADIP

[#7]

Hi Pradip

Both are unchecked already.

Further it is suppressing the value for grade A whichi have loaded inline, that means it surely and always 5 (for ideal curve)

[rajni_batra]

Use new Object fro actual data also, some time it happens QV bugs it seems.. if it is working fine on another object then u should use that,

i didnt find any problem in ur demo app

[#9 · Accepted solution]

i solved the issue by taking separate chart for ideal curve and put it on the actual chart by making its background transparent !!