Affect different filters in different objects of the same Sheet

[Diego_780]

Hello profesionals!

I have two exact tables, different objects, and I would like that each table is affected by two filters, but the problem is that one filter is dependant from the other, let´s say one is a general view of a module, and the other filter is a specific user in this module. Right now I have this:

As you see, Modulo_U is the more general filter, and Usuario is the specific user. I want the top table to stay the same, but the table below to show me this:

As you can see here, the 2nd table has the users that have this same module.

How can I achieve this?

Thank you!

[sbaro_bd]

Hi,

Can you take a look on "Alternate States"? Access link  on Qlik help : Alternate States. It can be helpful i guess.

Regards

[vincent_ardiet_ · Accepted solution]

If I follow you, you want the second table to be insensitive to the selection made on field "Usarios SAP"?
If this is the case, you can in the expression of this table, add a set analysis for this.
For example, if the current expression is :
Sum([MyMeasure])
You can replace by
Sum({<[Usarios SAP]>} [MyMeasure])

[Diego_780]

Yes! That´s what I wanted.

I have used Set Analysis like that in some other occasions, but I don´t know how it works. Can you explain me what it does exactly to have one dimension in the Set analysis?

Thank you!

[vincent_ardiet_]

In fact this is a simplification of this syntax: Sum({<[Usarios SAP]=>} [MyMeasure])
But the equal is not mandatory.
It means that you are clearing the field, "=" with nothing at the right is doing no selection, so all values.