Using selected filter dimension from one table on another?

[user467341]

Hi,

I have two data table not linked by any common dimension name.

In Qlik Sense, I have two straight table - Table1 and Table2. Is it possible to use Data Table A dimension 1 selected filter onto Data table B dimension 2?

For example, if I select 'Car' in my filter pane from Data Table A dimension 1, Table1 and Table2 will filter accordingly.

Both dimension data are the same (for eg, they all have fixed string like Car, Cat, Dog, Van) except the dimension name is different.

I can't associate both Data Tables due to other reasons.

[Chirantha]

You can use an alternate state to apply a selection from one table to another table that is not linked by a common dimension. Here’s how you can do it:

1. Create an alternate state by going to App options > States and clicking on Add state. Give the new state a name, for example “State1”.
2. Assign the alternate state to Table1 by going to the table’s properties panel, expanding the General section, and selecting “State1” from the Alternate state dropdown.
3. In Table2, use set analysis with the $ (dollar sign) expansion to reference the selection in the alternate state. For example, if your dimension in Table1 is called Dimension1 and your dimension in Table2 is called Dimension2, you can use the following expression to count the number of values in Dimension2 that match the selection in Dimension1:
   
   Count({$<[Dimension2] = P({[State1]<[Dimension1] = P([Dimension1])>} [Dimension1])>} [Dimension2])
    

[user467341]

Hi,

If it is just a normal dimension, how can I add the P() to it?

Also my measure is a calculation like:

(Sum(A)
- Sum({$<ZZ= {'Car', 'Van'}>} A)
/ Sum(B)

How can I modify it?

Thank you.