Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

If statement error

I'm try to mark the records with the following class codes for the account type. I created the following IF Statement to do it, but says Error in expression, and I have no clue. Help Please!

if ({<Account_Type_Description = {SAV},Class_Code = {41}>},'Yes',

if ({<Account_Type_Description = {DDA},Class_Code = {51,52,53,54}>},'Yes',

if ({<Account_Type_Description = {COD},Class_Code = {51}>},'Yes','No')))


1 Reply
Not applicable

Re: If statement error

May be this:


(Account_Type_Description = 'SAV' and Class_Code = 41) or

(Account_Type_Description = 'DDA' and Match(Class_Code, 51, 52, 53, 54)) or

(Account_Type_Description = 'COD' and Class_Code = 51),