Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zwyne
Creator
Creator

If Condition Question

Hello All,

I am not sure what's I doing here but my statement is

if (Match([Legal Entity],'Close Corporations','Co-Operatives','Foreign Companies','Partnerships','Pension, Provident and Other Funds'),
'Close Corporation','Co-operatives','Foreign Company','Partnership','Pension or provident funds',
[Legal Entity]) as CUSTOMER_TYPE_DESC

Please assist.

Regards

5 Replies
Anil_Babu_Samineni

Seems, You placed wrong place for Parenthesis.

if (Match([Legal Entity],'Close Corporations','Co-Operatives','Foreign Companies','Partnerships','Pension, Provident and Other Funds'),
'Close Corporation','Co-operatives','Foreign Company','Partnership','Pension or provident funds'),[Legal Entity]
) as CUSTOMER_TYPE_DESC

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vvvvvvizard
Partner - Specialist
Partner - Specialist

if legal entity matches any of those keywords it will return them

sunny_talwar

May be you need this

Pick(Match([Legal Entity], 'Close Corporations', 'Co-Operatives', 'Foreign Companies', 'Partnerships', 'Pension, Provident and Other Funds') + 1, [Legal Entity], 'Close Corporation', 'Co-operatives', 'Foreign Company', 'Partnership', 'Pension or provident funds') as CUSTOMER_TYPE_DESC

UPDATED: Updated based on Jonathan's response below

jonathandienst
Partner - Champion III
Partner - Champion III

Also comma after the second Legal Entity:

Pick(Match([Legal Entity], 'Close Corporations', 'Co-Operatives', 'Foreign Companies', 'Partnerships', 'Pension, Provident and Other Funds') + 1,

[Legal Entity], 'Close Corporation', 'Co-operatives', 'Foreign Company', 'Partnership', 'Pension or provident funds') as CUSTOMER_TYPE_DESC

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sunny_talwar

Thanks for pointing that out jontydkpi