Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
m_lavova
Contributor
Contributor

Filter Creation

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.

2 Replies
kawamuram
Creator II
Creator II

Hi,

Maybe, you can use outter join to combine those two columns.

Can you send your app?

Regards,

m_lavova
Contributor
Contributor
Author

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