topic Re: Traffic light issue in QlikView

Traffic light issue

Thu, 17 Jan 2013 07:32:33 GMT

hi,

Please find the attached a copy of sample application, i am using traffic light in expression in an object.

i need, if value is positive then show green and if value is negitive then show red.

Kindly any solution.

Zain.

Thu, 17 Jan 2013 08:23:57 GMT

Hi,

Right clik Chrt ->Expressions -> Gauge Settings...

Set Min and Max as desired values (say -9999999 and 9999999),

Then for Segment 1, set Lower Bound as -9999999 and for Segment 2, 1(or as per requirements).

Hope this solves your issue!

Regards,

Anju

Thu, 17 Jan 2013 08:43:41 GMT

Zain,

You can try this:

Change the Representation to Image for LED gauge and set the expression as:

=if(OD.quantity-OR.quantity>0,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

Additionally, if you need to change the numeric values to Red or Green, you can do it from Visual Cues tab in the chart properties.

Please find QVW attached.

Hope that helps.

Regards,

-Khaled

Thu, 17 Jan 2013 09:23:13 GMT

Thanks for your reply, I did before post but didnt success.

I resolved my problem and expression is (if(value<0,0,1)) and min 0 - max1 and segment 0 then red and segment 1 then green, its working fine to me.

Regards,

Zain.

Thu, 17 Jan 2013 09:25:01 GMT

Thanks for your reply, I know that but user want traffic light, any ways i done its.

Regards,

Zain.