Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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.