Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try
=If(WildMatch([Region1$.Segment],'*Name1*','*Name2*','*Name3*','*Name4*'),'Unit1',
If(WildMatch([Region2$.Segment],'*Name1*','*Name2*','*Name3*','*Name4*'), 'Unit1a'))
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