topic Traffic Led gauge setting in QlikView https://community.qlik.com/t5/QlikView/Traffic-Led-gauge-setting/m-p/150861#M28815 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I have an expression like following =DATA_PDR-Today()-Tipo_Raggrup.TMP_GG that calculate delay on days compared with a standard appointment date. (sign "-" means "in advance" sign "+" means delay)</P><P>The maximum days and minimum days could be for istance 1000 days and -1000 (is it possible to set a formula that calculate that max and min value ?)</P><P>I need to set the Traffic LED gauge with three color.</P><P>RED means that calculation sign is positive and &gt;0</P><P>ORANGE means that calculation result i 0</P><P>GREEN means that calculation sign is negative and &lt;0</P><P>I set Lower bound Red to 1 Orange to 0 and Green to -1 but the result is really bad.</P><P>Many thanks</P><P>Giovanni</P><P></P></BODY></HTML> Sat, 01 Aug 2009 14:10:25 GMT 2009-08-01T14:10:25Z Traffic Led gauge setting https://community.qlik.com/t5/QlikView/Traffic-Led-gauge-setting/m-p/150861#M28815 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I have an expression like following =DATA_PDR-Today()-Tipo_Raggrup.TMP_GG that calculate delay on days compared with a standard appointment date. (sign "-" means "in advance" sign "+" means delay)</P><P>The maximum days and minimum days could be for istance 1000 days and -1000 (is it possible to set a formula that calculate that max and min value ?)</P><P>I need to set the Traffic LED gauge with three color.</P><P>RED means that calculation sign is positive and &gt;0</P><P>ORANGE means that calculation result i 0</P><P>GREEN means that calculation sign is negative and &lt;0</P><P>I set Lower bound Red to 1 Orange to 0 and Green to -1 but the result is really bad.</P><P>Many thanks</P><P>Giovanni</P><P></P></BODY></HTML> Sat, 01 Aug 2009 14:10:25 GMT https://community.qlik.com/t5/QlikView/Traffic-Led-gauge-setting/m-p/150861#M28815 2009-08-01T14:10:25Z