topic Re: Combine filter OR mechanism and filter AND mechanism in App Development

Combine filter OR mechanism and filter AND mechanism

htdiepqlik — Thu, 24 Aug 2017 04:25:08 GMT

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.

Re: Combine filter OR mechanism and filter AND mechanism

htdiepqlik — Thu, 07 Sep 2017 11:44:26 GMT

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.

Re: Combine filter OR mechanism and filter AND mechanism

bernhard_koehle — Thu, 30 Nov 2017 12:10:29 GMT

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