label expression optimisation

samuel_brierley — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i have a chart with quite a lengthy expression that defines the colour of the bar and i was wondering if it could be optimised,

=if(EquipmentSetting_Id

= 20, rgb(102,51,0),

if(EquipmentSetting_Id

='30', rgb(255,128,0),

if(EquipmentSetting_Id

='40', rgb(255,255,0),

if(EquipmentSetting_Id

='50', rgb(102,0,102),

if(EquipmentSetting_Id

='60', rgb(0,255,0),

if(EquipmentSetting_Id

='98', rgb(255,0,0),

// if a sign is set at that location then colour the bar accordingly

(if(avg($(vCalc)) = -1,

rgb(0,0,255), //if no data make blue

if(vMeasure = 'Speed',

rgb((255-(255*(avg($(vCalc))/120))),(255-(255*(avg($(vCalc))/120))),(255-(255*(avg($(vCalc))/120)))),

if(vMeasure = 'Occupancy',

rgb((255-(255*(avg($(vCalc))/30))),(255-(255*(avg($(vCalc))/30))),(255-(255*(avg($(vCalc))/30)))),

rgb((255-(255*(avg($(vCalc))/20))),(255-(255*(avg($(vCalc))/20))),(255-(255*(avg($(vCalc))/20))))

// 3 measures based on user selection. Speed, occupancy and flow. these are displayed on a greyscale

))))))))))

not sure if this is needed but to provide a little context to the expression.

i have detectors and signs. the detectors detect speed, flow and occupancy (bottom half) and are displayed on a grayscale on the chart. depending on what the detectors detect signs are set (top half).

the dimension is location so easy to understand that bit.

thanks for any help.

Re: label expression optimisation

Anil_Babu_Samineni — Thu, 01 Dec 2016 12:07:25 GMT

How about this?

Pick(Match(EquipmentSetting_Id,'20','30','40','50','60','98'),Red(), Green(), Yellow(), Black(), Blue(), Violet(),

Then Use Expression here Then close parenthesis ")"

topic Re: label expression optimisation in QlikView

label expression optimisation

Re: label expression optimisation