Wildmatch Expression Error?

[#1]

So I am trying to group the data in a dimension to either IAA or EPA. I was using the following link as a guide:

Qlik Sense - Dimension Grouping (video)

The final expression from the video is as follows:

1. if(wildmatch(PRODNAME,'*Sony*'),'Sony', 
2. if(wildmatch(PRODNAME,'*Toshiba*'),'Toshiba', 
3. if(wildmatch(PRODNAME,'*Samsung*'),'Samsung','Other')))

I followed everything exactly, but I get an Error in Expression saying: Expecting ')'

I have simplified the expression to the one below:

If(wildmatch(Contracting Office Type,'*IAA*'),'IAA','EPA')

Can anyone tell me where I am going wrong? Most appreciated!

[sunny_talwar · Accepted solution]

I don't know if this is just a copy, but you don't have Square Brackets around your field name:

If(WildMatch([Contracting Office Type],'*IAA*'), 'IAA', 'EPA')

[#3]

Thank you so much, I knew that had to be issue, I just did not see the brackets in the example.

[sunny_talwar]

Yup . The example did not have it was because the field name did not have spaces and/or some special characters. Anytime you have spaces and special characters you need square brackets.