Filter Creation

m_lavova — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Filter Creation

Anonymous — Wed, 20 Jun 2018 19:51:37 GMT

Hi,

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

Can you send your app?

Regards,

Re: Filter Creation

m_lavova — Fri, 22 Jun 2018 07:31:55 GMT

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

topic Re: Filter Creation in QlikView

Filter Creation

Re: Filter Creation

Re: Filter Creation