Announcements
cancel
Showing results for
Did you mean:
MVP

## RE: Live colour change

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?

1 Solution

Accepted Solutions
Specialist

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.

3 Replies
Specialist

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,...))

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

MVP
Author

i need to show in top  one textbox object?

based on below table if red it wil show red  lik dat?

Specialist

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.

Community Browser