Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

if() explaination

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)),

            RGB(141, 170, 203)))

Thanks!!

1 Solution

Accepted Solutions
reshmakala
Creator III
Creator III

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

View solution in original post

2 Replies
vikramv
Creator III
Creator III

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
Creator III
Creator III

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