I am trying to use the expression based on the difference of two fields which I am displaying as Line to see the trend.
Trend is based calculated from
Blue value - Red value = green (displaying as a line to see the trend)
In an overall trend the output of the difference should not be negative.
A)when I am selecting the part of the combo chart the values are recalculated based on the selection and the trend is displaying negative values. Is there a way to prevent this and stop the trend to recalculate and just show the trend as overall trend.
![Overall trend.PNG Overall trend.PNG](https://community.qlik.com/t5/image/serverpage/image-id/8007i5610D55B185F26BF/image-size/large?v=v2&px=999)
Overall Trend Values
![Trend selection.PNG Trend selection.PNG](https://community.qlik.com/t5/image/serverpage/image-id/8005i5723FBFCF5D0744D/image-size/large?v=v2&px=999)
When selection a part
![Trend selection negative values because of recalculation.PNG Trend selection negative values because of recalculation.PNG](https://community.qlik.com/t5/image/serverpage/image-id/8008i9AA54EF78DEE0520/image-size/large?v=v2&px=999)
Negative Values based on recalculation.