Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Joker problem

Try this:

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

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