Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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

Community Browser