topic How To Adding Vertical Refference Line in a Chart with Non Numeric Dimensions in QlikView https://community.qlik.com/t5/QlikView/How-To-Adding-Vertical-Refference-Line-in-a-Chart-with-Non/m-p/351287#M577570 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a chart shown in picture below, but I can't adding a refference line like shown green line.</P><P></P><P>Any Solution as to how can I add these vertical lines in this chart?</P><P></P><P><IMG __jive_id="12128" alt="14-03-2012 11-51-58.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/12128_14-03-2012+11-51-58.png" /></P></BODY></HTML> Wed, 14 Mar 2012 05:02:15 GMT 2012-03-14T05:02:15Z How To Adding Vertical Refference Line in a Chart with Non Numeric Dimensions https://community.qlik.com/t5/QlikView/How-To-Adding-Vertical-Refference-Line-in-a-Chart-with-Non/m-p/351287#M577570 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a chart shown in picture below, but I can't adding a refference line like shown green line.</P><P></P><P>Any Solution as to how can I add these vertical lines in this chart?</P><P></P><P><IMG __jive_id="12128" alt="14-03-2012 11-51-58.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/12128_14-03-2012+11-51-58.png" /></P></BODY></HTML> Wed, 14 Mar 2012 05:02:15 GMT https://community.qlik.com/t5/QlikView/How-To-Adding-Vertical-Refference-Line-in-a-Chart-with-Non/m-p/351287#M577570 2012-03-14T05:02:15Z Re: How To Adding Vertical Refference Line in a Chart with Non Numeric Dimensions https://community.qlik.com/t5/QlikView/How-To-Adding-Vertical-Refference-Line-in-a-Chart-with-Non/m-p/351288#M577571 <HTML><HEAD></HEAD><BODY><P>Hi!! I have the same demand... very good if we find an answer...</P></BODY></HTML> Mon, 03 Sep 2012 08:54:01 GMT https://community.qlik.com/t5/QlikView/How-To-Adding-Vertical-Refference-Line-in-a-Chart-with-Non/m-p/351288#M577571 2012-09-03T08:54:01Z Re: How To Adding Vertical Refference Line in a Chart with Non Numeric Dimensions https://community.qlik.com/t5/QlikView/How-To-Adding-Vertical-Refference-Line-in-a-Chart-with-Non/m-p/351289#M577572 <HTML><HEAD></HEAD><BODY><P>Hi!! I have the same demand... very good if we find an answer...</P></BODY></HTML> Mon, 03 Sep 2012 08:54:10 GMT https://community.qlik.com/t5/QlikView/How-To-Adding-Vertical-Refference-Line-in-a-Chart-with-Non/m-p/351289#M577572 2012-09-03T08:54:10Z Re: How To Adding Vertical Refference Line in a Chart with Non Numeric Dimensions https://community.qlik.com/t5/QlikView/How-To-Adding-Vertical-Refference-Line-in-a-Chart-with-Non/m-p/351290#M577574 <HTML><HEAD></HEAD><BODY><P>Hi Ajay Bajay,&nbsp; try this method.</P><P></P><P>1. In script, add a column for the reference line. In my case, I put the reference line at Feb 2008.</P><P>&nbsp;&nbsp;&nbsp; The additional column script:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date(Monthstart(date('2/1/2008 12:00:00 AM')), 'MMM-YYYY') AS TargetMonth;</P><P></P><P>2. In the Presentation Tab of the chart, set the following expression for the Reference Lines:</P><P>. <IMG __jive_id="31587" class="jive-image-thumbnail jive-image" onclick="" alt="Reference line.png" src="/legacyfs/online/31587_Reference line.png" width="450" /></P><P></P><P>3. Chart with reference line.</P><P> <IMG __jive_id="31588" class="jive-image-thumbnail jive-image" onclick="" alt="chart.png" src="https://community.qlik.com/legacyfs/online/31588_chart.png" width="450" /></P></BODY></HTML> Wed, 23 Jan 2013 08:22:18 GMT https://community.qlik.com/t5/QlikView/How-To-Adding-Vertical-Refference-Line-in-a-Chart-with-Non/m-p/351290#M577574 2013-01-23T08:22:18Z