Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
is there someone, who can help me?
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?
Thank you in advance for your help.
Hi,
Maybe, you can use outter join to combine those two columns.
Can you send your app?
Regards,
Hello
thank you for your answer, I can check it, if it is good solution
it is not possible to sent my app. it contains "sensitive" data of our company