topic Dimension value in chart in QlikView

Dimension value in chart

Sun, 16 Oct 2011 05:59:15 GMT

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 — Sun, 16 Oct 2011 06:06:36 GMT

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

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

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

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

its_anandrjs — Sun, 16 Oct 2011 07:23:28 GMT

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