topic Re: Wildmatch on / in QlikView

Wildmatch on /

Tue, 31 May 2016 14:47:34 GMT

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

Re: Wildmatch on /

tamilarasu — Tue, 31 May 2016 15:49:10 GMT

Hi Sona,

You can try,

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

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

Re: Wildmatch on /

Tue, 31 May 2016 16:57:22 GMT

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

Re: Wildmatch on /

tamilarasu — Wed, 01 Jun 2016 02:12:38 GMT

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.