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.
Cencus Data.qvf 208.0 K
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.