topic Re: Show Specific Data in Text Object While Ignoring Filter in QlikView

Show Specific Data in Text Object While Ignoring Filter

Wed, 18 Mar 2015 16:51:45 GMT

Hello,

I am having trouble ignoring a specific filter (Record Type) when including a specific Category in my expression:

=num(sum({$*<[Record Type]=,[Category] = {'Events'}>} [Qualified]),'##,###.')

when using it without a specific category, this works fine:

=num(sum({<[Record Type]=>}[Qualified]),'##,###.')

What is wrong with my expression?

Thanks in advance!

-Jason

Re: Show Specific Data in Text Object While Ignoring Filter

rubenmarin — Wed, 18 Mar 2015 16:55:52 GMT

Hi Jason, I think is because the $* in the first expression, not because of the specific category

Re: Show Specific Data in Text Object While Ignoring Filter

Wed, 18 Mar 2015 16:58:14 GMT

Hi Ruben,

Removing the $* fixes the issue of ignoring the Record Type filter but I originally had to put that in because If I selected a different Category such as Telemarketing, the actual # of Qualified within Events would still show up rather than 0

Re: Show Specific Data in Text Object While Ignoring Filter

rubenmarin — Fri, 20 Mar 2015 07:56:57 GMT

Hi Jason, then you can use the '*' parameter only in the category field:

=num(sum({$<[Record Type]=,[Category] *= {'Events'}>} [Qualified]),'##,###.')

Re: Show Specific Data in Text Object While Ignoring Filter

Fri, 20 Mar 2015 08:31:41 GMT

Hi,

It is working.

=num(sum({$*<[Record Type]=,[Category] = {'Events'}>} [Qualified]),'##,###.')

Re: Show Specific Data in Text Object While Ignoring Filter

Mon, 23 Mar 2015 22:42:02 GMT

Perfect, thanks Ruben!