Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Re: If Condition Question

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

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)
Highlighted
Specialist
Specialist

Re: If Condition Question

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

Highlighted

Re: If Condition Question

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

Highlighted
MVP
MVP

Re: If Condition Question

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
Highlighted

Re: If Condition Question

Thanks for pointing that out jontydkpi