Wildmatch on /

[#1]

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

[tamilarasu · Accepted solution]

Hi Sona,

You can try,

=if(Isnum(Field),1,0)

or

=if(Isnum(Left(Field,1)),1,0)

[#3]

Thanks Nagaraj.. I used the second one and it worked

[tamilarasu]

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.