Discussion Board for collaboration related to QlikView App Development.
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.
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
Got it, thank you Stefan.
Have a nice weekend.