topic Re: if() explaination in QlikView

if() explaination

surajap123 — Fri, 06 Feb 2015 14:58:56 GMT

Hi Experts,

I am trying to understand the below expression. Could you please explan me this if() condition?

if (match (vField , 'A' , 'B'),

if(vField10='RM',

if (vField= 'A',

if ( Len(MinString($(vField5)))> 0 ,pick( max( Match ( $(vField5), $(vRed))),

$(vgreen) ),

RGB(141, 170, 203)),

RGB(141, 170, 203)))

Thanks!!

vikramv — Fri, 06 Feb 2015 15:06:18 GMT

if (vField = 'A' or 'B') and

if(vField10='RM') and

if (vFirmOutlet = 'A') and

if ( Len(MinString($(vField5)))> 0) And

Then if(vField5 = Red then RGB(141, 170, 203) ,vField5 = Green then RGB(141, 170, 203 else RGB(141, 170, 203))

Note : Len(MinString($(vField5)))> 0 : Length of the value of column vField5 greater than zero

reshmakala — Fri, 06 Feb 2015 15:14:15 GMT

if (match (vField , 'A' , 'B'), -> if vField matches 'A' or 'B'

if(vField10='RM', -> and if vField10 is 'RM'

if (vFirmOutlet = 'A', -> and if vFirmOutlet is 'A'

if ( Len(MinString($(vField5)))> 0 , -> and if the length of the condition is greater than 0 then

pick( max( Match ( $(vField5), $(vRed)) ), ->pick as per the condition

$(vgreen) ), -> else the value of vgreen

RGB(141, 170, 203)), ->else of third if condition

RGB(141, 170, 203)), ->else of second if condition

RGB(141, 170, 203))) -> else of first if condition