3 Replies Latest reply: Dec 17, 2015 3:13 PM by Sunny Talwar RSS

    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!