topic Re: How to plot Y-axis starting from zero in QlikView

How to plot Y-axis starting from zero

Thu, 16 Jul 2015 18:23:24 GMT

Hi,

I have a set of data

Time	Data
6:59 PM	0
7:01 PM	1
7:03 PM	1
7:05 PM	2
7:07 PM	2
7:09 PM	2
7:11 PM	3
7:13 PM	4
7:15 PM	4
7:17 PM	0
7:19 PM	0
7:21 PM	4
7:23 PM	4
7:25 PM	3
7:27 PM	3
7:29 PM	0
7:31 PM	0

I plotted Line Chart where "Time" is Dimensions X - Axis and "Data" is Expressions - Y-axis. In Qlikview for Y-axis, the chart begins with 1 at 7:01 pm and stops at the final value 3 at 7:31 pm. It never plots the 0 value at 6:59 pm. It remains flat at Data value 4 at 7:17 pm and 7:19 pm. The plot ends at 7:27 pm at value 3. I want the chart to start from zero. In Excel it plots correctly. How do I get QlikView to recognize 0?

I have applied "Forced 0" on Axes properties, Static Minimum = 0 in Scale section of the Axes properties. This is really odd. QlikView must use commonsense in plotting data, rather than tweaking with various options to plot a simple data.

Thanks,

Re: How to plot Y-axis starting from zero

antoniotiman — Thu, 16 Jul 2015 18:32:17 GMT

Have You unchecked 'Suppress 0 Value' ?

Re: How to plot Y-axis starting from zero

Gysbert_Wassenaar — Thu, 16 Jul 2015 18:34:19 GMT

On the Presentation tab disable the Suppress Zero-Values option

Re: How to plot Y-axis starting from zero

Thu, 16 Jul 2015 18:35:11 GMT

There is no option for "Suppress 0 Value". In "Dimensions" properties, there is an option "Suppress when value is Null" and it is unchecked.

Re: How to plot Y-axis starting from zero

Thu, 16 Jul 2015 18:37:18 GMT

It worked. Thanks Gysbert. Whew...Unbelievable..I learn small things about QlikView everyday. Thanks to Antonio too. I believe you might have referred to the same field.