How to affect visualisaiton with Filters

[srinihs]

Hi, I have two different tables from where i get data:

Table 1 - has Location (ex. London, Paris etc) and Name of individuals

Table 2 - has Site (ex. London, Paris etc) and Views

I want to keep Location and Site as separate parameters. I have created a simple visualisation table using the 4 attributes as above - Location - Name - Site - Sum of views 

I have also created a filter on Site, however when i select a particular site, i want the above table to update using the value in the Location column as opposed to Site column. How do i achieve this ?

Thanks for any insights,

[MatheusC]

@srinihs 

Search for alternative states, see more in the documentation, and qlik video

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Visualizations/alternate-...


https://help.qlik.com/en-US/video/NJvgT9WcNaVFaZA9Z88A7Z


- Matheus

[anat]

Table 1:

load Location as Site,Location, Name from table1;

Table 2:

load Site,Views from table2;

[TauseefKhan]

Use Alternate States. This allows you to create independent selections in different visualizations.

Steps to Implement
- Create Alternate States:
- Click on Alternate States and create a new state, for example, State1.

- Assign Alternate State to Filter Pane:
 Select your filter pane for Site.

 In the properties panel, under Alternate States, assign State1.

 In your visualization table, use set analysis to reference the alternate state.

-Create Visualization Table:
 Add a table visualization with the following dimensions and measures:

 Dimensions: Location, Name, Site

 Measure: Sum({<Site = P({State1::Site})>} Views)

ensures that the Views are filtered based on the Site selected in State1, but applied to the Location field.

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***

[srinihs]

Thanks for the recommendations so far, unfortunately the alternate state does not meet my requirement. Any other thoughts or ideas ?