I created app with source data from a lot of excel sheets. All source data sheets are connected. I avoided creation of synthetic key and cyrcle connections.
For one sheet of qlik app I used 3 different filters. Two of them work very well for all charts due to connection via Data Manager. But one works only for 2 charts. In this I would like to filter Regions for two different sorce data excel sheets - columns are named "Region table" and "Regions". It is not possible to concatenate source data excel sheets in one, because they contain different data, except cca 3 columns with similar content.
Is there some script, that I can use for the last filter, where I can connect Regions from two different souce?