topic Bypassing Sheet FIlters for a Single Object in QlikView

Bypassing Sheet FIlters for a Single Object

Mon, 03 May 2010 06:54:28 GMT

I had a search and could not find anything that was helpful so here we go...

We use a filter to remove data with a certain tag (Tag A). This works as intended because we don't want the data tagged Tag A included in the charts. However; we DO want to display a 'footnote' (I assume in the form of a text object...) that will display the total for data tagged as Tag A.

This is quite a pain because we can't get around the sheet filter for a single object.

Note: Coding the current charts to filter out Tag A is not an option we want to pursue because it would be days of work to modify all current expressions across multiple tabs.

Bypassing Sheet FIlters for a Single Object

disqr_rm — Mon, 03 May 2010 16:57:25 GMT

You could use Set Analysis to override any selection for a particular object. For example you could use following to show in the textbox for a footnote, which will INCLUDE records of all Tags:

='Total Sale= ' & sum({$<Tag=>} TOTAL NetSales)

By specifying Tag= (nothing after =), it supresses any selection made for that field (Tag, in this case).

Hope this helps you. Otherwise, an example QVW would be helpful to show what you are trying to do.

Bypassing Sheet FIlters for a Single Object

johnw — Tue, 04 May 2010 00:28:25 GMT

Or in this case, since I think we want JUST Tag A in the footnote:

='Total Sale= ' & sum({<Tag={'Tag A'}>} TOTAL NetSales)

Bypassing Sheet FIlters for a Single Object

Tue, 04 May 2010 00:48:13 GMT

Thank you both very much. This has solved my issue.

I am told this expression has common use in QV9 but I am still on 8.5 so I can't wait to get onto 9.