topic How to get Reference Lines in Chart ? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158147#M33350 <HTML><HEAD></HEAD><BODY><P>Sharma,</P><P>From my limited use of Reference Lines you should only need to use the 'Continuous' functionality when adding Reference Lines to the x-axis - ie a reference line at a particular time on a time series for instance like the below showin the start of the working day:</P><P></P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3021.X_2D00_axis.JPG"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/3021.X_2D00_axis.JPG" /></A></P></BODY></HTML> Mon, 25 Oct 2010 17:21:26 GMT matt_crowther 2010-10-25T17:21:26Z How to get Reference Lines in Chart ? https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158144#M33347 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I need help here for creating Reference Line (parallel to x-axis). The expression used is Sum(Sales). The Dimension being used is Month which has values from 1 to 12. But when I am trying to add Expression for Reference line (in Presentation tabà reference line), it is not showing up. Do I have to make x-axis as Continuous ? But after doing it, I am not getting it right and Months are not displaying properly. Do I have to write ab expression for Dimension top make it continuous? Any help is apreciated.</P><P>Below is the snapshot of what is needed.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2648_sourceID:2648" /></P><P></P></BODY></HTML> Mon, 25 Oct 2010 16:52:31 GMT https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158144#M33347 montubhardwaj 2010-10-25T16:52:31Z How to get Reference Lines in Chart ? https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158145#M33348 <HTML><HEAD></HEAD><BODY><P>To total across all months in view change the Reference expression to sum(Total Sales)</P><P>The reference line will be a long way above your bars though so you may need to adjuct your Y-axis to view it. You may be better off using 'Avg'.</P><P>Hope that helps.</P></BODY></HTML> Mon, 25 Oct 2010 17:00:22 GMT https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158145#M33348 matt_crowther 2010-10-25T17:00:22Z How to get Reference Lines in Chart ? https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158146#M33349 <HTML><HEAD></HEAD><BODY><P>Hi Matt,</P><P>I have another expression whcih I need to display in the reference line say Planned_Amount. For now, I have given Sum(Planned_Amount) in Reference Expression.</P><P>I think I need to make my X-axis continuous for doing the Reference Lines but not very sure how to do it.</P><P></P></BODY></HTML> Mon, 25 Oct 2010 17:07:15 GMT https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158146#M33349 montubhardwaj 2010-10-25T17:07:15Z How to get Reference Lines in Chart ? https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158147#M33350 <HTML><HEAD></HEAD><BODY><P>Sharma,</P><P>From my limited use of Reference Lines you should only need to use the 'Continuous' functionality when adding Reference Lines to the x-axis - ie a reference line at a particular time on a time series for instance like the below showin the start of the working day:</P><P></P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3021.X_2D00_axis.JPG"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/3021.X_2D00_axis.JPG" /></A></P></BODY></HTML> Mon, 25 Oct 2010 17:21:26 GMT https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158147#M33350 matt_crowther 2010-10-25T17:21:26Z How to get Reference Lines in Chart ? https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158148#M33351 <HTML><HEAD></HEAD><BODY><P>Hi Matt,</P><P>I think I got your point. But yes.... as you said,I am not able to view Reference line in the graph and may be is long way above the Bars.So what shall I do to make it display in the graph ?</P><P>Anyway thanks for your help.</P></BODY></HTML> Mon, 25 Oct 2010 18:50:06 GMT https://community.qlik.com/t5/QlikView/How-to-get-Reference-Lines-in-Chart/m-p/158148#M33351 montubhardwaj 2010-10-25T18:50:06Z