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: 
Not applicable

Grouping in the Data Manager

Hi,


I was trying to group data from a collumn in the 'Add Field' tool and using an if statement and inside some or's. somehow the expression is not valid, but can't find the error. I applied it inside the app, and it works, so the syntax is ok, but not in the 'Add Field' tool.

UsingOrInsideIF.JPG

Can you help me?

Thanks

1 Reply
ArnadoSandoval
Specialist II
Specialist II

Hi Dudley,

The expression's syntax for your field seems fine but it did not work for me when I tried locally, it does not like the ORs, then I tried a different approach, the WildMatch() function allows us to replace the ORs with a simple if-condition, like this:

if( (WildMatch(Area__C, 'Marketing', 'Finance', '*nge*')),'WildMatch', 'Y')

It works

Buble-New-Field.png

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.