Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 / ?
Hi Sona,
You can try,
=if(Isnum(Field),1,0)
or
=if(Isnum(Left(Field,1)),1,0)
Hi Sona,
You can try,
=if(Isnum(Field),1,0)
or
=if(Isnum(Left(Field,1)),1,0)
Thanks Nagaraj.. I used the second one and it worked
Sona,
. Could you take a moment to mark the reply as Correct.
Qlik Community Tip: Marking Replies as Correct or Helpful
Have a nice day.