3 Replies Latest reply: May 31, 2016 10:12 PM by Tamil Nagaraj RSS

    Wildmatch on /

    Sona Shetty

      Hi everyone

       

      I am new to qlikview and learning one step at a time.

       

      I have field that has values : 01/02/2015, LATE , Blank

       

      That is it either has a date, 'LATE' or a blank.

       

      In my load script I am creating a flag to indicate those which have dates.

       

      if(wildmatch(TRIM([Field]),'*/*'),1,0) as Flag.

       

      And then use a count of this flag in a chart

      =SUM( ALL Action_Plan_Completed)

       

      But the wildmatch is not working. Wild match works when I use LATE instead of / to flag all the 'LATE' records. Is there a different syntax for matching / ?