I want change color if selected Accounting Period (AP) is greater than current AP in Chart, but my implementation does not work, in the graphik example it should change from yellow to red if AP_KEY is greater or equal 27, see example app. Background color property of expression:
Good approach, but same effect, it does not work. I added a new example, any the funny thing ist ,the color does change but only if the Chart AP_Key ist equal $(vAP_KEY) but it should change color for all rows if AP_KEY is GREATER OR EQUAL THAN $(vAP_KEY) see new example, I have no clue what I am doing wrong.
Hi Sokkorn, I forgot to mention that it depends on the Time and not on the content of the value, say if the date (AP) is higher then the choosen Date, then I need to mark (in the example background color, in the real App a dotted line instead a normal line) , that means it is a forecast-value and not a demand-value.
I have the feeling I am really close, in the example you cann see if I chosse more than one AP, let say AP 4-8 the the lin is dotted or the background is red. What I need is the User only selects one AP, lets say AP = 4 and the dotted line or the background color is dotted resp. red for AP4 until endless (AP4 to AP12 in my case)