topic Re: Joker problem in QlikView

Joker problem

Thu, 11 Jun 2015 10:37:21 GMT

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

sunny_talwar — Thu, 11 Jun 2015 10:40:50 GMT

Try this:

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

sunny_talwar — Thu, 11 Jun 2015 10:43:09 GMT

Or may be this:

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

Tue, 16 Jun 2015 07:33:30 GMT

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!!!

maxgro — Tue, 16 Jun 2015 08:07:45 GMT

from my small test

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)