topic Re: aggr within set expression in QlikView https://community.qlik.com/t5/QlikView/aggr-within-set-expression/m-p/1210013#M878063 <HTML><HEAD></HEAD><BODY><P>Left hand side of the set modifiers do not allow for use of functions. May be use if statement or provide a sample with expected output so that we can help you find another way</P></BODY></HTML> Fri, 21 Oct 2016 15:42:39 GMT sunny_talwar 2016-10-21T15:42:39Z aggr within set expression https://community.qlik.com/t5/QlikView/aggr-within-set-expression/m-p/1210012#M878062 <HTML><HEAD></HEAD><BODY><P>Hello there,</P><P></P><P>could someone please help me if it is possible to somehow replace the <STRONG>Orders.ListPrice_Total</STRONG> within the expression below with <STRONG style="font-size: 10pt;">aggr(sum(Orders.ListPrice_Total),Orders.PO)?</STRONG></P><P></P><P>Count({$&lt; <STRONG>Orders.ListPrice_Total</STRONG> = {"&gt;=$(=$(V3_SmallOrderThreshold_lower))&lt;$(=$(V1_SmallOrderThreshold))"}&gt;} DISTINCT Orders.PO)</P><P></P><P>Regards,</P><P>Ales</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/aggr-within-set-expression/m-p/1210012#M878062 2020-11-25T16:16:04Z Re: aggr within set expression https://community.qlik.com/t5/QlikView/aggr-within-set-expression/m-p/1210013#M878063 <HTML><HEAD></HEAD><BODY><P>Left hand side of the set modifiers do not allow for use of functions. May be use if statement or provide a sample with expected output so that we can help you find another way</P></BODY></HTML> Fri, 21 Oct 2016 15:42:39 GMT https://community.qlik.com/t5/QlikView/aggr-within-set-expression/m-p/1210013#M878063 sunny_talwar 2016-10-21T15:42:39Z