topic Re: show 0 in line chart in QlikView

show 0 in line chart

Mon, 18 Mar 2013 11:44:31 GMT

hi everyone,

I created a line chart für the profit and the linechart has the day of a month and the years as dimensions. day is on the x-axis and year on the y-axis. so far so good. I always display the last 4 years. and for example: 2010 the 7th of march was a sunday and I didn't have any profit!! but my chart I not displaying it as 0. It basically makes a straight line to the next day with profit.

does anyone know how to solve this?

regards,

Re: show 0 in line chart

Mon, 18 Mar 2013 11:51:13 GMT

Hi,

Hope this helpful for you

Re: show 0 in line chart

Anonymous — Mon, 18 Mar 2013 12:20:47 GMT

hi,

Try this expression

if(isnull(sum(fieldname) or fieldname=' ',0,sum(fieldname))

where field name is your value or amount

Best wishes,

anant

Re: show 0 in line chart

udit_kumar_sana — Mon, 18 Mar 2013 12:20:55 GMT

Hi,

You can write like this in expression.

If(isnull(expression),'0',Expression)

Then tick mark show value on data points in expression tab for this expression.

Regards,

Udit

Re: show 0 in line chart

Tue, 19 Mar 2013 10:36:56 GMT

thanks for all your answers but none of your suggestions works. does anyone of you have another idea??

Re: show 0 in line chart

Tue, 19 Mar 2013 10:42:56 GMT

Hi,

Try going to properties in your line chart and in presentation tab,

uncheck 'Suppress zero-values' and check 'Zero on bars'

This should work fine.