i dont understand your Problem
result not in " " Setting and you become this table !
load * Inline [
Applicable, Reported, ResultSoll
Y, Y, Yes
Y ,N, Not Applicable
N, N, NA
If(Applicable='Y' and Reported='Y', 'Yes'
,if(Applicable='Y' and Reported='N', 'Not Applicable'
,If(Applicable='N' and Applicable='N', 'NA'))) as Result
drop Table myIF;
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.
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
QlikCommunity_Thread_309934.qvw 151.5 K