1 Reply Latest reply: Sep 7, 2017 7:44 AM by Diep Hoang Trong RSS

    Combine filter OR mechanism and filter AND mechanism

    Diep Hoang Trong

      Hi all,

       

      I have data from a excel file

      Region City

      A C1

      B C2

      C C3

      A C4

      B C5

      A C3

       

      I need to create a App as follows:

      In first sheet, I used a filter OR mechanism allows users to select data set for analysis. If i choose Region = A, City = C3, the expected result is

      Region City

      A C1

      C C3 <----- Region = A OR City = C3

      A C4

      A C3

      .

      Then, I use this result data set to analysis for the next sheets and use Qlik's default AND filter(associative mechanism). If i choose Region = A, City = C3, the expected result is

      Region City

      A C3 <--- Region = A AND City = C3

       

      Currently I don't have any suitable solution.