https://community.qlik.com/t5/QlikView/Problem-with-Set-Analysis/m-p/149702#M27846 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>This is the best I could do. It doesn't use set analysis, but aggr().</P><P></P><P>Regards,</P></BODY></HTML> Mon, 20 Jul 2009 15:35:13 GMT 2009-07-20T15:35:13Z https://community.qlik.com/t5/QlikView/Problem-with-Set-Analysis/m-p/149701#M27845 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>Somebody can help me?</P><P>I am beginning to use set Analysis.</P><P>in the sample attched I want to create a Pivot Table with the dimension year and dept.</P><P>I want to show only rows in which the sum of sales for the dept is greater than the avg of sales for all dept every year.</P><P></P><P>Thank All</P></BODY></HTML> Sun, 19 Jul 2009 22:32:57 GMT https://community.qlik.com/t5/QlikView/Problem-with-Set-Analysis/m-p/149701#M27845 2009-07-19T22:32:57Z https://community.qlik.com/t5/QlikView/Problem-with-Set-Analysis/m-p/149702#M27846 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>This is the best I could do. It doesn't use set analysis, but aggr().</P><P></P><P>Regards,</P></BODY></HTML> Mon, 20 Jul 2009 15:35:13 GMT https://community.qlik.com/t5/QlikView/Problem-with-Set-Analysis/m-p/149702#M27846 2009-07-20T15:35:13Z https://community.qlik.com/t5/QlikView/Problem-with-Set-Analysis/m-p/149703#M27847 <HTML><HEAD></HEAD><BODY><P>Thank 1000 Wernbrenk.</P><P>It is very goog</P></BODY></HTML> Mon, 20 Jul 2009 16:27:13 GMT https://community.qlik.com/t5/QlikView/Problem-with-Set-Analysis/m-p/149703#M27847 2009-07-20T16:27:13Z