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

    Wildmatch on /

      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 / ?