topic Standard Line on Bar/Line Chart in QlikView https://community.qlik.com/t5/QlikView/Standard-Line-on-Bar-Line-Chart/m-p/293232#M1192718 <HTML><HEAD></HEAD><BODY><P>Perfect</P><P></P><P>Thanks</P></BODY></HTML> Wed, 20 Jul 2011 11:58:06 GMT 2011-07-20T11:58:06Z Standard Line on Bar/Line Chart https://community.qlik.com/t5/QlikView/Standard-Line-on-Bar-Line-Chart/m-p/293230#M1192716 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have a bar/line chart that shows the average number of activities by person. The Optimum number that should be processed is 47.</P><P></P><P>I wish to have a line that crosses the graph at 47.</P><P>I have intially loaded it from a excel sheet, but when an option from a list box is selected to get a drill down view - this optimum line disappears, as its not relative to the list selection - Can I LOCK this line in at 47 ?</P><P></P><P>I have tried by not using a formula and just writing the demension at 47, but then it will extend out over the reporting period, see picture below. </P><P></P><P>Can anyone help with this please ?</P><P></P><P><IMG alt="Graph long optimum.bmp" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/5992_Graph+long+optimum.bmp" width="450" /></P></BODY></HTML> Wed, 20 Jul 2011 10:55:47 GMT https://community.qlik.com/t5/QlikView/Standard-Line-on-Bar-Line-Chart/m-p/293230#M1192716 2011-07-20T10:55:47Z Standard Line on Bar/Line Chart https://community.qlik.com/t5/QlikView/Standard-Line-on-Bar-Line-Chart/m-p/293231#M1192717 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>have you tried the reference line at presentation tab of (bar) chart properties?</P><P>Set expression to 47.</P><P></P><P>Stefan</P></BODY></HTML> Wed, 20 Jul 2011 11:04:22 GMT https://community.qlik.com/t5/QlikView/Standard-Line-on-Bar-Line-Chart/m-p/293231#M1192717 swuehl 2011-07-20T11:04:22Z Standard Line on Bar/Line Chart https://community.qlik.com/t5/QlikView/Standard-Line-on-Bar-Line-Chart/m-p/293232#M1192718 <HTML><HEAD></HEAD><BODY><P>Perfect</P><P></P><P>Thanks</P></BODY></HTML> Wed, 20 Jul 2011 11:58:06 GMT https://community.qlik.com/t5/QlikView/Standard-Line-on-Bar-Line-Chart/m-p/293232#M1192718 2011-07-20T11:58:06Z