Moving from IF statement to Pick&Match .

[kalyanamharish]

Hello All,

I was wondering how can i write the below IF statement using Pick & Match/Wildmatch functions.

=IF(CountryFlag=0 and CountryToggle=0,EmpID,
If(CountryFlag=1 and CountryToggle=1,EmpID))

Thank you. 

[Qlik1_User1]

please share the sample data and complete scenario.

[sergio0592 · Accepted solution]

Hi,

Just try with

=pick(match(CountryFlag&Countrytoggle,00,11),EmpId,EmpId)