topic Aggr Function - How to return expression results to each row in QlikView https://community.qlik.com/t5/QlikView/Aggr-Function-How-to-return-expression-results-to-each-row/m-p/876800#M306163 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm struggling with the best way to say it but basically I need to aggregate on a single dimension but need to return the results on each row of a straight table which has more dimensions. I have included an example which makes it more clear.</P><P></P><P>The easiest thing to do would be to use the AGGR function in the dimension, but I can't do this as I need to set the field as a "Link" which can only be done as an expression.</P><P></P><P>Any help or guidance would be MUCH appreciated. Thanks!</P></BODY></HTML> Tue, 21 Apr 2015 15:44:35 GMT 2015-04-21T15:44:35Z Aggr Function - How to return expression results to each row https://community.qlik.com/t5/QlikView/Aggr-Function-How-to-return-expression-results-to-each-row/m-p/876800#M306163 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm struggling with the best way to say it but basically I need to aggregate on a single dimension but need to return the results on each row of a straight table which has more dimensions. I have included an example which makes it more clear.</P><P></P><P>The easiest thing to do would be to use the AGGR function in the dimension, but I can't do this as I need to set the field as a "Link" which can only be done as an expression.</P><P></P><P>Any help or guidance would be MUCH appreciated. Thanks!</P></BODY></HTML> Tue, 21 Apr 2015 15:44:35 GMT https://community.qlik.com/t5/QlikView/Aggr-Function-How-to-return-expression-results-to-each-row/m-p/876800#M306163 2015-04-21T15:44:35Z Re: Aggr Function - How to return expression results to each row https://community.qlik.com/t5/QlikView/Aggr-Function-How-to-return-expression-results-to-each-row/m-p/876801#M306164 <HTML><HEAD></HEAD><BODY><P>I think you can use the total qualifier like this</P><P>=date(aggr(max(TOTAL &lt;[Org Name]&gt; Date),[Org Name],Role,Type))</P></BODY></HTML> Tue, 21 Apr 2015 15:54:02 GMT https://community.qlik.com/t5/QlikView/Aggr-Function-How-to-return-expression-results-to-each-row/m-p/876801#M306164 stigchel 2015-04-21T15:54:02Z Re: Aggr Function - How to return expression results to each row https://community.qlik.com/t5/QlikView/Aggr-Function-How-to-return-expression-results-to-each-row/m-p/876802#M306165 <HTML><HEAD></HEAD><BODY><P>Piet Hein van der Stigchel - Perfect! I knew there was an easy solution to this. Thank you very much.</P></BODY></HTML> Tue, 21 Apr 2015 15:57:34 GMT https://community.qlik.com/t5/QlikView/Aggr-Function-How-to-return-expression-results-to-each-row/m-p/876802#M306165 2015-04-21T15:57:34Z