https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1787394#M1210200 <P>Hi</P><P>I am trying to reconcile activity accross a data set</P><P>So I have 4 columns ID, Date, Table &amp; Count.</P><P>In the Table column there are 3 columns, I have a pivot which is ID &amp; Date, Table across the top and then sum of count.</P><P>I want to filter where the count is not the same for all 3 tables, I think i can use the AGGR function within set analysis, but can't seem to get it to work</P> Tue, 02 Mar 2021 09:46:53 GMT jono19872002 2021-03-02T09:46:53Z https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1787394#M1210200 <P>Hi</P><P>I am trying to reconcile activity accross a data set</P><P>So I have 4 columns ID, Date, Table &amp; Count.</P><P>In the Table column there are 3 columns, I have a pivot which is ID &amp; Date, Table across the top and then sum of count.</P><P>I want to filter where the count is not the same for all 3 tables, I think i can use the AGGR function within set analysis, but can't seem to get it to work</P> Tue, 02 Mar 2021 09:46:53 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1787394#M1210200 jono19872002 2021-03-02T09:46:53Z