Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Wildmatch Expression Error?

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!

1 Solution

Accepted Solutions
MVP
MVP

Re: Wildmatch Expression Error?

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 Replies
MVP
MVP

Re: Wildmatch Expression Error?

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')

Not applicable

Re: Wildmatch Expression Error?

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

MVP
MVP

Re: Wildmatch Expression Error?

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.

Community Browser