Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MK_QSL
MVP
MVP

Try

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

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

Not applicable
Author

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