Dimension value in chart

[#1]

Hi All,

I have dimension YearMonth in chart. In qlikview If we dont have values for any particular YearMonth it will not display that YearMonth On chart.

I want to display 0 on chart for that particular YearMonth if it does not have any values . How can I do this?

[SunilChauhan]

If( isnull(Value) = 0 , Sum(Value) , 0 )

chart properties->presentation-> supress zero value->uncheck the checkbox

or

If( len(Value)= 0, 0 , Sum(Value)  )

chart properties->presentation-> supress zero value->uncheck the checkbox

[its_anandrjs]

Hi,

You have to show some thing like in

Dimension -> YearMonth

Expression -> If( isnull(Value) = -1 ,  0 , Sum(Value) )

And in presentation select expression and Uncheck -> Suppress Zero-Values properties

Let me know

Rgds

Anand