Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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