Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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