If Statement help

[#1]

Hi Qlikviewers,

I'm trying to construct a if statement containing the following codition, below is  the condition. Please let me know what's wrong with my statement.

Global Org =  Org1 = 'CD' or 'CM' or 'EI' or ('Risk' and Org2 = CC and IA)

Global Risk= Org1 = 'Risk' and Org 2 = REM, FRM, GRM.

if(match(org1='CD','CM','EI','Risk' AND match(Org2='CC','IA'),Global Org, if(match(org1='Risk' and Org2('REM', 'FRM', 'GRM'), Global Risk)) AS group1

Thank you!

[Gysbert_Wassenaar]

if(match(org1='CD','CM','EI') or (org1='Risk' AND match(Org2='CC','IA')),Global Org,

if(match(org1='Risk' ) and match(Org2,'REM', 'FRM', 'GRM'), Global Risk)) AS group1

[PrashantSangle]

Hi,

Try this

if(match(org1,'CD','CM','EI','Risk') AND match(Org2,'CC','IA'),Global Org, if(match(org1,'Risk') and Match(Org2,'REM', 'FRM', 'GRM'), Global Risk)) AS group1

Syntax:

Match(expr,expr1,expr2)

Regards

[its_anandrjs]

Hi,

Write like

if(match(org1='CD','CM','EI','Risk') AND ( AND match(Org2='CC','IA')),Global Org,

if(match(org1='Risk' ) and match(Org2,'REM', 'FRM', 'GRM'), Global Risk)) AS group1

Thanks & Regards