How to prevent the selection/filter on a table from affecting another table on the sheet

[RyCarm]

Hi all,

I am new to Qlik Sense and I just have a simple question:

I have 2 tables on 1 sheet.

Using Set Analysis, I notice that when I select a field or when I select a value in a column of Table1 (for filtering purposes), table 2 also filters and is adjusted based on my selection. Is there a way to make it so you can filter 1 table while continuing to show all of the values in Table 2, and vice versa?

I just want both tables to act independently and not get affected by the other.

Is there a way to do this?

Thank you in advance for any help that I can get!

- Ryan

[joseph_morales]

Hi @RyCarm 

If you are using set analysis, you can ignore the fields that do not affect your calculation as follows: 

Sum({<Year={2020},Product=>}Price)

Where, "Product=" indicates that the calculation ignores any selection on the Product field.

[RyCarm]

Joseph,

Thanks for the quick reply.

Set Analysis aside, I'm more so just wondering if you can filter a table without another table being affected on the same sheet?

Thanks,

- Ryan

[RyCarm · Accepted solution]

SOLUTION:

For anyone wondering about this, you can make your tables act independently from each other by creating alternate states and applying them to different charts/visualizations on the sheet. This way, visualizations on your sheet will only be linked to other visualizations that SHARE THAT SAME alternate state.

Hope this helps someone!

- Ryan

[joseph_morales]

@RyCarm 

You can achieve is, apart from the set analysis, you can use alternate states in the visualizations.

https://www.youtube.com/watch?v=LMMGAFgrnc8