Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
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
pokassov
Specialist
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.

View solution in original post

3 Replies
pokassov
Specialist
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,...))

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
MVP
MVP
Author

i need to show in top  one textbox object?

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

live.png

pokassov
Specialist
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.