Re: IF / OR STATEMENT HELP

Bharathi09 — Mon, 19 Sep 2022 09:49:21 GMT

I have one requirement

I have dataset with columns parts and code

I need to add new country column in script like :

if any of the code = 34 or 35 country = Canada

if any of the code =14, 20 OR 43 country = Mexico

if any of the code = 34 or 35 and 14, 20 OR 43 country = Both

all this should be appear as country column

Please help

Thanks in advance

Re: IF / OR STATEMENT HELP

Vadimb — Mon, 19 Sep 2022 10:54:15 GMT

Hi,

try this

,if(WildMatch(code, 34,35), 'Canada'
,if(WildMatch(code, 14,20,43), 'Mexico'
,if(WildMatch(code, 34,35) AND WildMatch(code, 14,20,43), 'Both'))) as country

topic Re: IF / OR STATEMENT HELP in QlikView

Re: IF / OR STATEMENT HELP

Re: IF / OR STATEMENT HELP