topic 'IF', 'OR', 'WILDMATCH' in a single comment. in QlikView

'IF', 'OR', 'WILDMATCH' in a single comment.

Architect — Sat, 16 Nov 2024 01:11:51 GMT

Somehow I am stuck with a script, and not able to figure out the meaning of the below logic.

Please explain what is the meaning of this line -

"if([Product Name] = 'Bucket' or WildMatch([Group Name],'*aa-wt*','*aa-wp*'),1,0) as _ProductFlag"

Re: 'IF', 'OR', 'WILDMATCH' in a single comment.

DavidM — Tue, 25 Feb 2020 13:54:42 GMT

For product with name 'Bucket' or group names containing strings aa-wt, aa-wp (characters can be in front, or behind that string) the ProductFlag is set 1, for all others it is set to 0

Re: 'IF', 'OR', 'WILDMATCH' in a single comment.

Architect — Wed, 26 Feb 2020 07:36:11 GMT

Hi David,

Thanks for the reply. Is there any other way to represent the same logic in code.

As I am facing some Bug while working with this line of code.

Re: 'IF', 'OR', 'WILDMATCH' in a single comment.

DavidM — Wed, 26 Feb 2020 08:13:09 GMT

Can you describe the mistake? As the code seems to be ok.

You can use nested if for example:

if([Product Name] = 'Bucket',1,

if(WildMatch([Group Name],'*aa-wt*','*aa-wp*'),1,0)) as _ProductFlag