topic Question about set analysis in QlikView https://community.qlik.com/t5/QlikView/Question-about-set-analysis/m-p/396393#M1149782 <HTML><HEAD></HEAD><BODY><P>I am trying to Concat all of our companies that has a sum of sales greater than 500 in the last 7 days</P><P></P><P>This is what I tried doing so far and it is breaking because of the sum around the sales, what I was wondering was if it is possible to even set the field selection in a sum.</P><P></P><P>Concat({&lt;sum({&lt;[date range] = {"LAST 7 DAYS"}&gt;}sales) = {"&gt;=500"}&gt;}company, ', ')</P></BODY></HTML> Wed, 22 May 2013 15:42:06 GMT 2013-05-22T15:42:06Z Question about set analysis https://community.qlik.com/t5/QlikView/Question-about-set-analysis/m-p/396393#M1149782 <HTML><HEAD></HEAD><BODY><P>I am trying to Concat all of our companies that has a sum of sales greater than 500 in the last 7 days</P><P></P><P>This is what I tried doing so far and it is breaking because of the sum around the sales, what I was wondering was if it is possible to even set the field selection in a sum.</P><P></P><P>Concat({&lt;sum({&lt;[date range] = {"LAST 7 DAYS"}&gt;}sales) = {"&gt;=500"}&gt;}company, ', ')</P></BODY></HTML> Wed, 22 May 2013 15:42:06 GMT https://community.qlik.com/t5/QlikView/Question-about-set-analysis/m-p/396393#M1149782 2013-05-22T15:42:06Z