topic Re: Count & Wildmatch ( '*-??') in QlikView

Count & Wildmatch ( '*-??')

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

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

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

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

swuehl — Fri, 16 Jun 2017 10:26:50 GMT

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

Use something like

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

Anonymous — Fri, 16 Jun 2017 10:30:59 GMT

Got it, thank you Stefan.

Have a nice weekend.