Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Regards,
Zela
HI,
Create a key based on Date filed in 2 tables, this will be easy and simple option.
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...