if statement

[Luben]

HOW DO I PUT THIS IN AN IF STATEMENT FOR QLIK SENSE.

[QFabian · Accepted solution]

Hi @Luben , can be like this?

lOAD
if(
(isnull(ORIGIN_COUNTRY) and match(PORT_COUNTRY,'US','CA') >0) or
match(ORIGIN_COUNTRY,'US','CA') > 0, 'EXPORT',

if(
((isnull(DESTINATION_COUNTRY) and match(DISCHARGE_COUNTRY,'US','CA') >0) and
match(PORT_COUNTRY,'US','CA') = 0) or
(match(DESTINATION_COUNTRY,'US','CA') > 0 and
match(PORT_COUNTRY,'US','CA') = 0), 'IMPORT')) as Direction

RESIDENT A;

[Luben]

thank you so much for your input.

[Luben]

Hello could you please give me a brief explanation on the above if statement so I could understand it properly.

thanks

[QFabian · Accepted solution]

Hello @Luben , i just tried to put the logic to get one new field.

• Following the possible ways from your schema.
• Putting togheter with 'and' when the logic allows me to create that combination.
• Using 'or' to add a new way ir posibility.

For example, the beggining of that logic is :

If ORIGIN_COUNTRY is null, and PORT_COUNTRY is 'US' or 'CA', ....

match(ORIGIN_COUNTRY,'US','CA') > 0

That 'match' function search in the field used as first parameter, the text used un second and more parameters.

If it found something , is going yo give you a value above 0, indicating the position, and if it doesnt find what are you looking for, it gives you 0.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Condi...

[Luben · Accepted solution]

thank you so much for your explanation. I guess the only question i have, is this part of the logic when its not 
US or CA part i think it missing in the query. I might be wrong.