Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Filtering From Multiple Tables

Hi, I am currently using filters for things such as product category. However, the data that I am filtering from has multiple tables(by region) with the same column names but are not associated with each other. I would like to apply the filter to all visualizations in the page, regardless of which table each visualization pulls data from. Is this possible? Ideally, I would prefer not to join the tables together, but am open to any suggestions.

ie

If(WildMatch([Region1$.Segment],

'*Name1*',

'*Name2*',

'*Name3*',

'*Name4*'), 'Unit1')

However, I would like to filter Region1$.Segment as well as Region2$.Segment


I tried to do this:

If(WildMatch([Region1$.Segment],

'*Name1*',

'*Name2*',

'*Name3*',

'*Name4*'), 'Unit1',

(If(WildMatch([Region2$.Segment],

'*Name1*',

'*Name2*',

'*Name3*',

'*Name4*'), 'Unit1a',))


However, this makes my Qlik Sense stop working. Is there any other way I can do this? Thank you so much!

2 Replies
MVP
MVP

Re: Filtering From Multiple Tables

Try

=If(WildMatch([Region1$.Segment],'*Name1*','*Name2*','*Name3*','*Name4*'),'Unit1',

  If(WildMatch([Region2$.Segment],'*Name1*','*Name2*','*Name3*','*Name4*'), 'Unit1a'))

Not applicable

Re: Filtering From Multiple Tables

Hi Manish,

I just tried this (removing the parenthesis around the second if statement) and it still makes Qlik Sense freeze up. Is there anything else you could think of/know why this would happen?

Thanks very much