Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Chanty4u
Esteemed Contributor III

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
pokassov
Valued Contributor

Re: RE: Live colour change

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
pokassov
Valued Contributor

Re: RE: Live colour change

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
Esteemed Contributor III

Re: RE: Live colour change

i need to show in top  one textbox object?

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

live.png

pokassov
Valued Contributor

Re: RE: Live colour change

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.