Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

noobie_wiz
New Contributor III

Trend line as expression based on Field A - Field B issue.

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 Values

 

Trend selection.PNG

When selection a part

Trend selection negative values because of recalculation.PNG

Negative Values based on recalculation.