topic Re: Wilematch text filtering and count in QlikView

Wilematch text filtering and count

Evan0211 — Thu, 01 Dec 2022 14:56:39 GMT

I have a request to do some text filtering (which I know is a bad idea but unfortunately it's the only option at this time) and I am trying to get the totals in an overview table.

The overview table looks like this

No. of Entries

Title

Low

Medium

High

The No. of Entries is simply:

=if( Match([OFFICE_CODE], $(vFilterOffice)), count(R_TITLE) )

That is working fine. The Low, Medium, High counts however always return -

I have tried the following different methods and can not get the count to return.

=if(wildmatch(R_TITLE, '*Low*'), count(R_TITLE))

=if( Match([OFFICE_CODE], $(vFilterOffice)), ( if(wildmatch(R_TITLE, '*Low*'), count(R_TITLE) ) ) )

Any ideas?

Re: Wilematch text filtering and count

Or — Thu, 01 Dec 2022 15:01:53 GMT

Try moving the match statement inside the count() statement, rather than vice versa, e.g.

Count(wildmatch(R_TITLE,'*Low*'))

or Count(if(WildMatch(R_TITLE,'*Low*'),1))

Or using set analysis rather than if() statements.

Re: Wilematch text filtering and count

Evan0211 — Thu, 01 Dec 2022 15:16:22 GMT

Thank you, moving it inside the count statement worked.