topic Re: Remove ONE filter into formulas in QlikView

Remove ONE filter into formulas

yannick001 — Mon, 14 Jun 2021 17:12:22 GMT

Hello,

I have an application, with a first page that allow the users to setup some filters, that apply to the whole application (50 sheets approx). For Example they will setup 3 filters like: Client = Client_A, year = 2020, product in (Product1, Product2, Product7)

It can be 3 or more (or less, or none) filters, base on specific dates, sub products,... and it may be evolutive.

In some formulas (quite a lot), I would like to keep the same filters, EXCEPT ONLY ONE: I would like to remove the filtering based on Client...

Do you have an idea on how I could do that?

Thank you in advance for your help

Re: Remove ONE filter into formulas

JuanGerardo — Mon, 14 Jun 2021 17:40:49 GMT

Hi @yannick001, you can use Set Analysis to exclude one specific field from your formulas, for example to exclude any Client selection in sales:

Sum({<Client>} Sales)

Sum({<Client, Product>} Sales)

to exclude Client and Product selections.

Re: Remove ONE filter into formulas

yannick001 — Tue, 15 Jun 2021 08:26:01 GMT

Thank you @JuanGerardo , this is exactly what I was looking for