topic Re: Moving from IF statement to Pick&Match . in QlikView

Moving from IF statement to Pick&Match .

kalyanamharish — Sat, 16 Nov 2024 01:16:46 GMT

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 — Fri, 14 Feb 2020 13:51:15 GMT

please share the sample data and complete scenario.

sergio0592 — Fri, 14 Feb 2020 15:26:47 GMT

Hi,

Just try with

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