3 Replies Latest reply: May 9, 2017 8:39 AM by Dan Coen RSS

    Exclude Data from a Wildmatch Expression

    Dan Coen

      Hi, I need to exude data from a wildmatch expression in QlikSense

       

      If(WildMatch([Item - Item Number], '10-401' , '10-403'), ' Classic',

      If(WildMatch([Item - Item Number], '401LITE' , '401LITE'), 'Lite',

      If(WildMatch([Item - Item Number], '403FC' , '401FC'), 'Reach',

      If(WildMatch([Item - Item Number], '401XL' , '501XL' , '503XL' ), 'XL',

      If(WildMatch([Item - Item Number], 'KITUS' , '3US' , '03167' , 'PRD-03146'), 'Advanced',

      If(WildMatch([Item - Item Number], '00910' , 'NS2' , 'NS20' ), 'Classic',

      'Unspecified'))))))

       

      This expression is used to return revenue on the groupings, however, I would like to exclude "Unspecified" data from the expression entirely. 

       

      Any suggestions?

       

      Thanks!