topic Re: Line chart in QlikView https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293219#M869926 <HTML><HEAD></HEAD><BODY><P>Seem I am still missing what is defining these ranges.</P></BODY></HTML> Tue, 22 Nov 2016 23:39:01 GMT swuehl 2016-11-22T23:39:01Z Line chart https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293214#M869921 <HTML><HEAD></HEAD><BODY><P>Hello Developers</P><P>I have a line chart in which i created 4 reference lines that shows the range value. If i select any lab the line chart should display only the reference line that lab has the value range. The other reference lines should not be displayed. Can someone help me please.</P><P></P><P>Thanks</P><P>Anil </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293214#M869921 dandaanilreddy 2020-11-25T16:16:04Z Re: Line chart https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293215#M869922 <HTML><HEAD></HEAD><BODY><P>"<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> If i select any lab the line chart should display only the reference line <EM>that lab has the value range.</EM> "</SPAN></P><P></P><P>Sorry, I don't understand this. Could you elaborate further?</P><P></P><P>In general, you can use the show condition in the reference line properties, but it seems you already discovered this.</P></BODY></HTML> Tue, 22 Nov 2016 23:17:31 GMT https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293215#M869922 swuehl 2016-11-22T23:17:31Z Re: Line chart https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293216#M869923 <HTML><HEAD></HEAD><BODY><P>Hi Stefan</P><P>Thanks for the reply.</P><P>In the below image the CD pass upper limit line should not be displayed. The reference lines should be displayed according to the range of the selected lab.</P><P></P><P><IMG alt="line chart.PNG" class="jive-image image-1" src="/legacyfs/online/144578_line chart.PNG" style="height: 143px; width: 620px;" /></P></BODY></HTML> Tue, 22 Nov 2016 23:20:56 GMT https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293216#M869923 dandaanilreddy 2016-11-22T23:20:56Z Re: Line chart https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293217#M869924 <HTML><HEAD></HEAD><BODY><P>In the version you've uploaded, the reference line is not shown, it's only shown for lab 'ARUP'.</P><P></P><P>edit: You can change the condition to </P><P>=SubstringCount( Concat(Distinct Lab,'|'), 'ARUP')</P><P></P><P>to also show the line when nothing is selected (so whenever ARUP is a <EM>possible</EM> value in lab value range).</P></BODY></HTML> Tue, 22 Nov 2016 23:30:41 GMT https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293217#M869924 swuehl 2016-11-22T23:30:41Z Re: Line chart https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293218#M869925 <HTML><HEAD></HEAD><BODY><P>Yes Stefan. I want these condition should apply for all labs. The reference lines should display only the range for each selected lab.</P><P></P><P>Thanks</P><P>Anil</P></BODY></HTML> Tue, 22 Nov 2016 23:33:29 GMT https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293218#M869925 dandaanilreddy 2016-11-22T23:33:29Z Re: Line chart https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293219#M869926 <HTML><HEAD></HEAD><BODY><P>Seem I am still missing what is defining these ranges.</P></BODY></HTML> Tue, 22 Nov 2016 23:39:01 GMT https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293219#M869926 swuehl 2016-11-22T23:39:01Z Re: Line chart https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293220#M869927 <HTML><HEAD></HEAD><BODY><P>Stefan</P><P>In the above screen shot i have selected the lab genetica. There are 4 reference lines in that chart the blue line is not reaching the CD pass limit line as the range value is greater than the range value of that lab. That reference line should not appear in the chart. </P><P></P><P>Thanks</P><P>Anil</P></BODY></HTML> Tue, 22 Nov 2016 23:46:50 GMT https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293220#M869927 dandaanilreddy 2016-11-22T23:46:50Z Re: Line chart https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293221#M869928 <HTML><HEAD></HEAD><BODY><P>Maybe use a condition that checks the max range value against your reference line value?</P></BODY></HTML> Tue, 22 Nov 2016 23:54:22 GMT https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293221#M869928 swuehl 2016-11-22T23:54:22Z Re: Line chart https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293222#M869929 <HTML><HEAD></HEAD><BODY><P>Thanks Stefan <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks</P><P>Anil</P></BODY></HTML> Wed, 23 Nov 2016 00:03:06 GMT https://community.qlik.com/t5/QlikView/Line-chart/m-p/1293222#M869929 dandaanilreddy 2016-11-23T00:03:06Z