2 Replies Latest reply: Apr 7, 2017 11:05 AM by Bradley Qian RSS

    Filtering From Multiple Tables

    Bradley Qian

      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!