topic Re: Filtering on Pre Calculated Data in QlikView https://community.qlik.com/t5/QlikView/Filtering-on-Pre-Calculated-Data/m-p/1156713#M918433 <HTML><HEAD></HEAD><BODY><P>Check my response here: <A href="https://community.qlik.com/thread/217161">Filtering on Pre Calculated Data</A></P></BODY></HTML> Tue, 17 May 2016 16:51:06 GMT sunny_talwar 2016-05-17T16:51:06Z Filtering on Pre Calculated Data https://community.qlik.com/t5/QlikView/Filtering-on-Pre-Calculated-Data/m-p/1156712#M918432 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am very new to Qlik and need to know how I am able to filter on previous aggregated data. </P><P></P><P>I'm a simplified way, my columns consist of something like this: (in reality I have many more dimensions) </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Device</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Unique users</STRONG></TH></TR><TR><TD style="padding: 2px;">FRANCE</TD><TD style="padding: 2px;">NULL</TD><TD style="padding: 2px;">50000</TD></TR><TR><TD style="padding: 2px;">FRANCE</TD><TD style="padding: 2px;">IPHONE</TD><TD style="padding: 2px;">24000</TD></TR><TR><TD style="padding: 2px;">FRANCE</TD><TD style="padding: 2px;">ANDROID</TD><TD style="padding: 2px;">26000</TD></TR></TBODY></TABLE><P></P><P>I want the dashboard filter to be built so that when a user selects Country = FRANCE that it should only return 50,000 unique users and not a sum of all rows containing FRANCE. (For those familiar with SQL this was achieved via GROUPING SETS). </P><P></P><P>How is this best achieved in Qlik? Alternatively, is it better to not work with Pre calculated data and do the aggregations within Qlik itself? If so, how? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Filtering-on-Pre-Calculated-Data/m-p/1156712#M918432 2020-11-25T16:16:04Z Re: Filtering on Pre Calculated Data https://community.qlik.com/t5/QlikView/Filtering-on-Pre-Calculated-Data/m-p/1156713#M918433 <HTML><HEAD></HEAD><BODY><P>Check my response here: <A href="https://community.qlik.com/thread/217161">Filtering on Pre Calculated Data</A></P></BODY></HTML> Tue, 17 May 2016 16:51:06 GMT https://community.qlik.com/t5/QlikView/Filtering-on-Pre-Calculated-Data/m-p/1156713#M918433 sunny_talwar 2016-05-17T16:51:06Z