topic Re: combo chart not plotting 0 ?? in QlikView

combo chart not plotting 0 ??

Wed, 01 Aug 2012 08:37:52 GMT

Hi,

I'm building a combo chart like below.

The line value for May is 0, and i have the option "suppress zero value" checked.

Is there a way, i can still have a dot at 0 for May's line ?

Otherwise, it's very misleading, isnt it?

or is this already a known bug ?

Re: combo chart not plotting 0 ??

jonathandienst — Wed, 01 Aug 2012 08:56:20 GMT

If zeroes are suppressed, what value should be shown for the line in May? If you want to force a zero to show for May and not elsewhere, you may have to fake it by using a very small non-zero value.

What basis do you have for showing the zero for May, and not for Jan and Feb?

Regards

Jonathan

Re: combo chart not plotting 0 ??

Wed, 01 Aug 2012 09:14:37 GMT

Hi Jonathan,

That's what i'm doing now, to put an IF statement around the formula and plot 0.0001 when the formula return 0.

The formula is something like (A1 - B1) / A1.

but only when both A1 and B1 is not 0, then plot the line with its figures..