Combine filter OR mechanism and filter AND mechanism

[htdiepqlik]

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.

[htdiepqlik]

Hi all,

I have solution for filter OR mechanism in first sheet.

But i can't use this result data set to analysis and use Qlik's default AND filter(associative mechanism).

I am looking forward for your helping.

[bernhard_koehle]

Hi Diep,

i am not sure if you have seen my solution  (  Solution for filtering data by using AND + OR at the same time in Qlik Sense 3.2  ).

But i beleave that this app can solve your problems. There is an example app for downloading including sampledata.

Perhaps you can modify it to your own conditions.

Regards

Bernhard