Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
masch112
Creator
Creator

Count & Wildmatch ( '*-??')

Hello everyone,

I'd like to count Management-IDs (companies) for certain business areas.

I only want to count those ManIDs that end with '-??'. CountManIDs.JPG

In this example, only the 33 ManIDs at the bottom should be counted (the ones that end with -01/-02 etc.)

I've tried the displayed expression but I don't fully understand the wildmatch function yet, the returned value is 2.

Thanks for your help.

Best regards,

Mats

1 Solution

Accepted Solutions
swuehl
MVP
MVP

The Wildmatch() will return either 0 or 1, that's what you count.

Use something like

=Count( DISTINCT If(Wildmatch(..), [Management ID]))

View solution in original post

2 Replies
swuehl
MVP
MVP

The Wildmatch() will return either 0 or 1, that's what you count.

Use something like

=Count( DISTINCT If(Wildmatch(..), [Management ID]))

View solution in original post

masch112
Creator
Creator
Author

Got it, thank you Stefan.

Have a nice weekend.