topic Re: RE: Live colour change in QlikView

RE: Live colour change

Chanty4u — Fri, 26 Feb 2016 12:00:12 GMT

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?

pokassov — Fri, 26 Feb 2016 12:08:06 GMT

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

Chanty4u — Fri, 26 Feb 2016 12:17:19 GMT

i need to show in top one textbox object?

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

pokassov — Fri, 26 Feb 2016 12:42:12 GMT

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.