https://community.qlik.com/t5/QlikView/Trend-line-as-expression-based-on-Field-A-Field-B-issue/m-p/1556514#M440884 <P><EM>I am trying to use the expression based on the difference of two fields which I am displaying as Line to see the trend.</EM></P><P><EM>Trend is based calculated from</EM></P><P><STRONG>Blue value - Red value = green (displaying as a line to see the trend)</STRONG></P><P><U>In an overall trend the&nbsp; output of the difference should not be negative.</U></P><P>A)when I am selecting the part of the <EM>combo chart the values are recalculated</EM> based on the <EM>selection</EM> and the trend is <U><EM>displaying negative values</EM></U>. Is there a way to prevent this and stop the trend to recalculate and just show the trend as overall trend.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Overall trend.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8007i5610D55B185F26BF/image-size/large?v=v2&amp;px=999" role="button" title="Overall trend.PNG" alt="Overall trend.PNG" /></span></P><P>Overall Trend Values</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Trend selection.PNG" style="width: 305px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8005i5723FBFCF5D0744D/image-size/large?v=v2&amp;px=999" role="button" title="Trend selection.PNG" alt="Trend selection.PNG" /></span></P><P>When selection a part</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Trend selection negative values because of recalculation.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8008i9AA54EF78DEE0520/image-size/large?v=v2&amp;px=999" role="button" title="Trend selection negative values because of recalculation.PNG" alt="Trend selection negative values because of recalculation.PNG" /></span></P><P>Negative Values based on recalculation.</P> Sat, 16 Nov 2024 04:10:20 GMT wiz_nerd 2024-11-16T04:10:20Z https://community.qlik.com/t5/QlikView/Trend-line-as-expression-based-on-Field-A-Field-B-issue/m-p/1556514#M440884 <P><EM>I am trying to use the expression based on the difference of two fields which I am displaying as Line to see the trend.</EM></P><P><EM>Trend is based calculated from</EM></P><P><STRONG>Blue value - Red value = green (displaying as a line to see the trend)</STRONG></P><P><U>In an overall trend the&nbsp; output of the difference should not be negative.</U></P><P>A)when I am selecting the part of the <EM>combo chart the values are recalculated</EM> based on the <EM>selection</EM> and the trend is <U><EM>displaying negative values</EM></U>. Is there a way to prevent this and stop the trend to recalculate and just show the trend as overall trend.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Overall trend.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8007i5610D55B185F26BF/image-size/large?v=v2&amp;px=999" role="button" title="Overall trend.PNG" alt="Overall trend.PNG" /></span></P><P>Overall Trend Values</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Trend selection.PNG" style="width: 305px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8005i5723FBFCF5D0744D/image-size/large?v=v2&amp;px=999" role="button" title="Trend selection.PNG" alt="Trend selection.PNG" /></span></P><P>When selection a part</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Trend selection negative values because of recalculation.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8008i9AA54EF78DEE0520/image-size/large?v=v2&amp;px=999" role="button" title="Trend selection negative values because of recalculation.PNG" alt="Trend selection negative values because of recalculation.PNG" /></span></P><P>Negative Values based on recalculation.</P> Sat, 16 Nov 2024 04:10:20 GMT https://community.qlik.com/t5/QlikView/Trend-line-as-expression-based-on-Field-A-Field-B-issue/m-p/1556514#M440884 wiz_nerd 2024-11-16T04:10:20Z