topic Re: Different traffic light bounds based on dimension value in QlikView

Different traffic light bounds based on dimension value

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm trying to write some logic for a traffic light within one of my tables (below). Basically, I want to set different bounds for what defines red, yellow, and green for EE Paid, ER Paid, and Other. Specifically, EE Paid should be green if Column 3 is >= 0.32 and yellow if Column 3 is between 0.28 and 0.31, and red otherwise. ER Paid should be green if Column 3 is >=0.04, yellow if Column 3 is greater than 0.02 but less than 0.04, and red otherwise. Other should be the same bounds as ER paid. I have the below code, but it's not working. Thanks for your help!

Code for Bounds:

Red: 0

Yellow: if(Payer='EE Paid', 0.28, if(Payer='ER Paid', 0.03, 0.03))

Green: if(Payer='EE Paid', 0.32, if(Payer='ER Paid', 0.04, 0.04))

Re: Different traffic light bounds based on dimension value

sunny_talwar — Mon, 01 Aug 2016 20:40:16 GMT

Is this the goal?

Expression:

=If(Payer = 'EE Paid',

If(Column3 < 0.28, 'qmem://<bundled>/BuiltIn/led_r.png',

If(Column3 < 0.31, 'qmem://<bundled>/BuiltIn/led_y.png', 'qmem://<bundled>/BuiltIn/led_g.png')),

If(Payer = 'ER Paid',

If(Column3 < 0.02, 'qmem://<bundled>/BuiltIn/led_r.png',

If(Column3 < 0.04, 'qmem://<bundled>/BuiltIn/led_y.png', 'qmem://<bundled>/BuiltIn/led_g.png'))))

Re: Different traffic light bounds based on dimension value

Mon, 01 Aug 2016 20:58:16 GMT

Perfect! Thank you!