Discussion board where members can get started with Qlik Sense.
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:
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!
Go to 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')
Thank you so much, I knew that had to be issue, I just did not see the brackets in the example.
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.