topic Filters based on different sets of data aggregation in QlikView https://community.qlik.com/t5/QlikView/Filters-based-on-different-sets-of-data-aggregation/m-p/21580#M779291 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Below is my filters for an application. Due to the way data is structured in the database, I need two sets of queries to get correct amount output. For instance, first query is aggregated by Unit, Region and State; second query is aggregated by all columns.</P><P></P><P>What's the best way to combine these two data set (two queries) so that the correct value gets rendered:</P><P>1) when Unit, Region, state is selected the values should come from first query</P><P>2) when County, City, Zip, Type, Program is selected the values should come from second query</P><P></P><P>I still want to see the corresponding county, city, zip, type, program for each Unit, Region and State though.<IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199328_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT newqlik2017 2020-11-25T16:16:04Z Filters based on different sets of data aggregation https://community.qlik.com/t5/QlikView/Filters-based-on-different-sets-of-data-aggregation/m-p/21580#M779291 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Below is my filters for an application. Due to the way data is structured in the database, I need two sets of queries to get correct amount output. For instance, first query is aggregated by Unit, Region and State; second query is aggregated by all columns.</P><P></P><P>What's the best way to combine these two data set (two queries) so that the correct value gets rendered:</P><P>1) when Unit, Region, state is selected the values should come from first query</P><P>2) when County, City, Zip, Type, Program is selected the values should come from second query</P><P></P><P>I still want to see the corresponding county, city, zip, type, program for each Unit, Region and State though.<IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199328_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Filters-based-on-different-sets-of-data-aggregation/m-p/21580#M779291 newqlik2017 2020-11-25T16:16:04Z