By now I nearly solved the problem myself with applying the following expression:
=if( Num#( [Alter Wert BELEG] ) <= Num#( [Neuer Wert BELEG] ),2,if( Num#( [Neuer Wert BELEG] ) <= Num#( [Alter Wert BELEG] ),1,0))
What I still did not figure out is:
is it also possible to have the color changed when there is more than one value selected with different combinations of "Alter Wert" and "Neuer Wert".
Example: Select "Geschäftsjahr=2016" - two values (BelegNr) possible, but none directly selected. Therefore, the gauge chart displays only gray. However, since one value is considered critical ("Alter Wert" smaller than "Neuer Wert") the red light would be required.
So, I need to include the condition to have the red light shown whenever there is one or more values critical, even in combination with non-critical values.
I hope this is somehow understandable.
Gauge Chart Problem.qvw 221.8 K