Need to nested if condition replace with pick match function

[Anonymous]

I am working on table. I have table Like -

Applicable	Reported	Result
Y	Y	Yes
Y	N	Not Applicable
N	N	NA

I have done this issues using the "Nested If" condition.

like -

If(Applicable='Y' and Reported='Y', 'Yes'

    ,if(Applicable='Y' and Reported='N', 'Not Applicable'

    ,If(Applicable='N' and Applicable='N', 'NA'))) as "Result"

but I want to do this using the "Pick and Match function" because there is two condition (Applicable and Reported). how it possible.

Please help.

[gerry_hdm]

i dont understand your Problem

result not in " " Setting and you become this table !

myIF:
load * Inline [
Applicable, Reported, ResultSoll
Y, Y, Yes
Y ,N, Not Applicable
N, N, NA
];
EndeFile:
load *,
If(Applicable='Y' and Reported='Y', 'Yes'
,if(Applicable='Y' and Reported='N', 'Not Applicable'
,If(Applicable='N' and Applicable='N', 'NA'))) as Result
resident myIF;

drop Table myIF;

[Anonymous]

Hi Gerold Roser

my question is 

Result = "Yes",  if Applicable = "Y" and Reported = "Y"

Result = "Not Applicable" ,  If Applicable  ="Y" and Reported = "N"

Result  = "NA" , If Applicable  =  "N" and Reported = "N".

I have done this issues with Nested If Condition. but I want to do this issues with "Pick and Match" function.

[gerry_hdm]

Re: Multiple IF, PICK AND MATCH

see here 🙂

[undergrinder]

Hi Sushant,

If these are the only possible states, then try this expression:

=pick(match('N',Applicable,Reported)+1,'Yes','NA','Not Applicable')

It assumes when Applicable='N' then the Reported field is also 'N'

G.

[undergrinder]

and don't manage that situation, when one of the fields is null

[MarcoWedel]

Hi,

another solution might be:

table1:
LOAD Applicable,
    Reported,  
    Pick(Match(Applicable&'/'&Reported,
          'N/N' , 'N/Y'       , 'Y/N'            , 'Y/Y'),
          'NA'  , 'undefined' , 'Not Applicable' , 'Yes'
        ) as Result
FROM [https://community.qlik.com/thread/309934] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco