topic Re: If Condition Question in QlikView

If Condition Question

zwyne — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: If Condition Question

Anil_Babu_Samineni — Thu, 19 Jul 2018 13:22:10 GMT

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

Re: If Condition Question

vvvvvvizard — Thu, 19 Jul 2018 13:27:28 GMT

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

Re: If Condition Question

sunny_talwar — Thu, 19 Jul 2018 13:30:50 GMT

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

Re: If Condition Question

jonathandienst — Thu, 19 Jul 2018 13:39:33 GMT

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

Re: If Condition Question

sunny_talwar — Thu, 19 Jul 2018 13:42:53 GMT

Thanks for pointing that out jontydkpi