Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
@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
Table 1:
load Location as Site,Location, Name from table1;
Table 2:
load Site,Views from table2;
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.***
Thanks for the recommendations so far, unfortunately the alternate state does not meet my requirement. Any other thoughts or ideas ?