topic If Statement help in QlikView

If Statement help

Thu, 20 Mar 2014 13:55:25 GMT

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!

Re: If Statement help

Gysbert_Wassenaar — Thu, 20 Mar 2014 13:59:36 GMT

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

Re: If Statement help

PrashantSangle — Thu, 20 Mar 2014 14:01:29 GMT

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

Re: If Statement help

its_anandrjs — Thu, 20 Mar 2014 14:11:27 GMT

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