# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Not applicable

## Joker problem

Hej - I got a probem with counting digits out of a row of digits.

I want to count the digits marked with red = 0100171350104015.

Mabye something lik this....

count ({<AAR={\$(vCurrentYear)},item1={'****1713501040**'}>}item2)

But it dosn't work!

How do I do it?

Best regard

Jesper

4 Replies
MVP

## Re: Joker problem

Try this:

=Count ({<AAR={\$(vCurrentYear)}>} If(WildMatch(item1, '*171351040*'), item2))

MVP

## Re: Joker problem

Or may be this:

=Count ({<AAR={\$(vCurrentYear)}, item1 = {"=If(WildMatch(Item1, '*171351040*)"}>} item2)

Not applicable

## Re: Joker problem

Hey

Sorry for the late answer, but I was busy!

No one is working - am I right somthing is missing in the latest syntax:

=Count ({<AAR={\$(vCurrentYear)}, item1 = {"=If(WildMatch(Item1, '*171351040*)"}>} item2)?

I assume a ' is missing where the red cross is - even thoug is not working!

I left out the counting current year and tryed this:

Count (JOURNALNR = {=If(WildMatch(,'*171351040*')}>} JOURNALNR))

But still its not working!!!

MVP

## Re: Joker problem

from my small test

a:

load rowno() as item2, * inline [

item1

0100171350104015

01713501040

000001713501040

0171350104015

0100171350104014

1713501040

713501040

171350104

];

count ( {\$ <item1={"*1713501040*"}>} item2)                    --> 6 (bold)

count ( {\$ <item1={"????1713501040??"}>} item2)         --> 2 (underline)

Community Browser