Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a stright table.with in that i hve multiple expressions.
So my requirmnt is in that table there is diff between Planned Vs actual value >10 it shud be dispaly red
<5 green in beetwen 5 to 10 it show yellow.
it is ging exactly...
but i need to dispaly one indictor on top as GO:LIVE:- Red() or Green() or yellow() [This colur is based on stright table colour.
1)if any one of colur is red---- live status shud be red
2)if all green ----Live green
3)if all yellow-----Lie yellow?
How can achive this?
Yes.
You can use textbox and images
=if(vStat=1,'qmem://<bundled>/BuiltIn/led_r.png',
if(vStat=2, 'qmem://<bundled>/BuiltIn/led_y.png',
'qmem://<bundled>/BuiltIn/led_g.png'))
Where vStat is a calculated variable.
Hello!
You can use aggr() and variable.
Somthing like that:
=min(aggr(
if(sum(Planned)-sum([actual value])>10, 1,
if(sum(Planned)-sum([actual value])>5, 2, 3
)
)
),Dim1, Dim2,...))
Where Dim1, Dim2 are your dimensions in your straight table.
So you will have 1 for red, 2 for yellow, 3 for green.
And you will be able this value to get colour.
Best regards,
Sergey
i need to show in top one textbox object?
based on below table if red it wil show red lik dat?
Yes.
You can use textbox and images
=if(vStat=1,'qmem://<bundled>/BuiltIn/led_r.png',
if(vStat=2, 'qmem://<bundled>/BuiltIn/led_y.png',
'qmem://<bundled>/BuiltIn/led_g.png'))
Where vStat is a calculated variable.