The Linear Gauge segments are looking for a single value for colour.
If you really need a highlighted bar perhaps try using repeating symbols in the straight table cell to make your own in-cell graphic,
or use more than one linear gauge to show highlighted variance,
see attached qvw,
NotALinearGuage.qvw 140.0 K
I tried to dig into the issue and found that the calculated color expression doesn't get affected by the dimensionality of the chart. The expression will be applied on the entire dataset. It will return same result as if it is inside a text box.
Although I don't think this should be the right way of implementation by Qliktech ,I guess the solution provided by Donald might help you this time.
Digging up an old thread...
I was trying out this approach in v11.2 and I run into a annoying issue.
As long as there are several lines in the table it works fine but when there is only one line or the/a negative line is at the bottom it looks strange. It is as though the background extends outside the table box.
Several lines, negative last:
Only one line:
And here again with 400% zoom:
Does anybody know if there is a solutin for this? Or is there a better solution in later versions?