https://community.qlik.com/t5/App-Development/Line-graph-Conditional-reference-line/m-p/1785139#M61209 <P>Hi,</P><P>I need som help. I would like to create a a lower limit reference line which value is depends on date. (you see on the bottom a green line changes from -0.7 to -0.8 but it is not a reference line it is a measure it this case).<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49666iFF5FEB5B291B07F3/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>&nbsp;</P><P>I tried with the next expression but it not works.</P><P>=if([Full date])&lt;date#('2021-02-19', 'YYYY-MM-DD'),-0.7,if([Full date]&gt;=date#('2021-02-19', 'YYYY-MM-DD'),-0.8,2))</P><P>&nbsp;</P><P>Could anyone help how to change the expression?</P> Sat, 16 Nov 2024 00:32:57 GMT gprejlek 2024-11-16T00:32:57Z https://community.qlik.com/t5/App-Development/Line-graph-Conditional-reference-line/m-p/1785139#M61209 <P>Hi,</P><P>I need som help. I would like to create a a lower limit reference line which value is depends on date. (you see on the bottom a green line changes from -0.7 to -0.8 but it is not a reference line it is a measure it this case).<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49666iFF5FEB5B291B07F3/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>&nbsp;</P><P>I tried with the next expression but it not works.</P><P>=if([Full date])&lt;date#('2021-02-19', 'YYYY-MM-DD'),-0.7,if([Full date]&gt;=date#('2021-02-19', 'YYYY-MM-DD'),-0.8,2))</P><P>&nbsp;</P><P>Could anyone help how to change the expression?</P> Sat, 16 Nov 2024 00:32:57 GMT https://community.qlik.com/t5/App-Development/Line-graph-Conditional-reference-line/m-p/1785139#M61209 gprejlek 2024-11-16T00:32:57Z