Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 

Filtering using values from another table



I have two separate tables with different lists of countries in each. I need to create filter pane using Country field from Master table (I have attached the example), but I also want to create a bar chart from Table 1 to respond to the Country filter.

Moreover, as you can see, the names of the countries are not the same, for example: 'UK' in Master table and 'United Kingdom' in Table 1.

Both lists of the countries need to be loaded. Bar chart which is using data from Table 1, should display countries from Table 1, but need to be responsive to Country filter which is using data from Master table.




Labels (1)
2 Replies
Specialist III
Specialist III


 Create a key based on Date filed in 2 tables, this will be easy and simple option. 


Creator III
Creator III


In the data manager you may be able to adjust the field to take the country abbreviation and convert to name. It must be as the Country code is though. EX. US instead of USA. 

Some info on this:https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/LoadData/changing-date-t...