This content has been marked as final. Show 3 replies
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 / ?