topic Re: Expression problem in QlikView

Expression problem

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

HI all,

Can any one let me know the actual logic of below expression:?

Why Sum key is used in this logic ? Cant we use in IF statement as sum (TPressure) for every well name?

If(

Sum(

(Name of Well = 'BW B8' and (TPressure) > 10) or

(Name of Well = 'B1 o.B' and (TPressure > 5) or

(Name of Well = 'B2 o.B.' and TPressure > 5) or

(Name of Well = 'B5 o.B.' and TPressure > 5) or

(Name of Well = 'B4 m.B.' and TPressure > 5) or

(Name of Well = 'B1 M.' and TPressure > 5) or

(Name of Well = 'B2 M.' and TPressure > 5) or

(Name of Well = 'B3 M.' and TPressure > 5) or

(Name of Well = 'B4 M.' and TPressure > 5) or

(Name of Well = 'TB01' and TPressure > 3) or

(Name of Well = 'B1' and TPressure > 5) or

(Name of Well = 'B2' and TPressure > 5) or

(Name of Well = 'STO500' and TPressure > 5)

)

, RGB(242,28,10) , RGB(255,255,255))

Regards

MANU

Re: Expression problem

YoussefBelloum — Wed, 06 Jun 2018 12:21:45 GMT

Hi,

is it working ? just try to remove the Sum() and see if the colors is working properly

Re: Expression problem

Anil_Babu_Samineni — Wed, 06 Jun 2018 13:31:59 GMT

This won't give BG color. Reason is you need the condition like

If(Sum()= ..., Color1, Color2)

If(Sum()> ..., Color1, Color2)

If(Sum()< ..., Color1, Color2) ... ETC.

Re: Expression problem

kfoudhaily — Wed, 06 Jun 2018 13:44:55 GMT

this expression should return color RGB(242,28,10) if any of the conditions bellow is true else RGB(255,255,255)

in case of removing the sum.

regards,

Re: Expression problem

andre_mueller — Wed, 06 Jun 2018 13:46:15 GMT

Hi Manu,

Your expression returns RGB(242,28,10) if one or more of the conditions in the Sum() are true, else RGB(255,255,255).

With the Sum it still returns that RGB(242,28,10) even if multiple values are possible or selected in a field, for example „Name of Well“ has ‘BW B8’ and ‘B1 o.B’ or more selected.

If you remove the Sum and use the ‘If’ only, then for example “Name of Well” has to have exactly one value (e.g. onl ‘BW B8’) to return RGB(242,28,10). If multiple values are possible or selected, then the result will be RGB(255,255,255).

Hope my comments helps you to understand the difference.

Kind regards

Re: Expression problem

manu1512 — Wed, 06 Jun 2018 20:15:03 GMT

its is working

Re: Expression problem

MarcoWedel — Wed, 06 Jun 2018 23:30:07 GMT

Sum() is used as logical "or" aggregation of the boolean expression, i.e. if any of the single terms aggregated over your dimension is true, then the if condition will be true thus returning RGB(242,28,10).

hope this helps

regards

Marco