topic Re: Graph Axes minimum in QlikView https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332591#M1169357 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Is not start with zero... Its start with one only.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Please see the attached file.</P></BODY></HTML> Wed, 01 Aug 2012 14:38:18 GMT MayilVahanan 2012-08-01T14:38:18Z Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332583#M1169349 <HTML><HEAD></HEAD><BODY><P>I have a single table within a QVW file with (amongst others) 3 columns for 10/11 Activity, 11/12 Activity and 12/13 Activity.</P><P><BR />When graphing this to compare year on year activity levels, the axis of the graph always starts at zero as months 6-12 of 12/13 Activity are null/zero.</P><P><BR />Is there a way of getting QV to ignore nulls/zeros so I can get the graph on the right?</P><P>I have tried using static min but of course once filters are applied, this min value causes data not to be viewed?</P><P><BR />Thanks</P><P></P><P>Ian</P><P><IMG __jive_id="19256" alt="Zero.bmp" class="jive-image" height="240" src="https://community.qlik.com/legacyfs/online/19256_Zero.bmp" width="289" /><IMG __jive_id="19258" alt="Required.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/19258_Required.bmp" /></P></BODY></HTML> Wed, 01 Aug 2012 13:51:40 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332583#M1169349 2012-08-01T13:51:40Z Re: Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332584#M1169350 <HTML><HEAD></HEAD><BODY><P>Hi Ian,</P><P></P><P>You can uncheck the option "Forced 0" for all of your expressions in the "Axes" tab of the chart.</P><P></P><P></P><P>Regards,</P><P>Cesar</P></BODY></HTML> Wed, 01 Aug 2012 13:59:20 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332584#M1169350 cesaraccardi 2012-08-01T13:59:20Z Re: Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332585#M1169351 <HTML><HEAD></HEAD><BODY><P>Already done Cesar, but no effect. Axes still show from zero</P><P>Ian</P></BODY></HTML> Wed, 01 Aug 2012 14:01:11 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332585#M1169351 2012-08-01T14:01:11Z Re: Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332586#M1169352 <HTML><HEAD></HEAD><BODY><P>Have you tried with the "Supress Zero-Values" option at Presentation tab checked?</P></BODY></HTML> Wed, 01 Aug 2012 14:03:00 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332586#M1169352 cesaraccardi 2012-08-01T14:03:00Z Re: Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332587#M1169353 <HTML><HEAD></HEAD><BODY><P>Yes, with the box unticked you can clearly see the line hitting zero in the later months, with the box ticked, the line is hidden bu the graph axis remains the same.</P><P></P><P>Thanks for trying!</P></BODY></HTML> Wed, 01 Aug 2012 14:07:47 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332587#M1169353 2012-08-01T14:07:47Z Re: Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332588#M1169354 <HTML><HEAD></HEAD><BODY><P>I understand... When you uncheck the Forced 0 option it will start from the minimum value you have, if you have 0 values for some dimensions you need to supress these values. Can you post your qvw or a sample?</P></BODY></HTML> Wed, 01 Aug 2012 14:14:38 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332588#M1169354 cesaraccardi 2012-08-01T14:14:38Z Re: Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332589#M1169355 <HTML><HEAD></HEAD><BODY><P>Another important thing is that the option Forced 0 must be unchecked for each expressions you have individually.</P></BODY></HTML> Wed, 01 Aug 2012 14:16:39 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332589#M1169355 cesaraccardi 2012-08-01T14:16:39Z Re: Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332590#M1169356 <HTML><HEAD></HEAD><BODY><P>QVW now attached Cesar.</P><P><BR />Thanks</P><P></P><P>Ian</P></BODY></HTML> Wed, 01 Aug 2012 14:29:57 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332590#M1169356 2012-08-01T14:29:57Z Re: Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332591#M1169357 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Is not start with zero... Its start with one only.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Please see the attached file.</P></BODY></HTML> Wed, 01 Aug 2012 14:38:18 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332591#M1169357 MayilVahanan 2012-08-01T14:38:18Z Re: Graph Axes minimum https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332592#M1169358 <HTML><HEAD></HEAD><BODY><P>Please take a look, I made a verification for the first expression ensuring it wont return 0 values.</P><P></P><P>Regards,</P><P>Cesar</P></BODY></HTML> Wed, 01 Aug 2012 14:54:28 GMT https://community.qlik.com/t5/QlikView/Graph-Axes-minimum/m-p/332592#M1169358 cesaraccardi 2012-08-01T14:54:28Z