topic Re: Help in aggr function! in QlikView https://community.qlik.com/t5/QlikView/Help-in-aggr-function/m-p/610146#M225191 <HTML><HEAD></HEAD><BODY><P>this expression </P><P>calculate the result for each unique instance of Business and Business_Unit</P><P>and create a list of values for each unique value</P><P></P><P>so you should get a result for each unique instance </P></BODY></HTML> Mon, 07 Apr 2014 12:42:34 GMT lironbaram 2014-04-07T12:42:34Z Help in aggr function! https://community.qlik.com/t5/QlikView/Help-in-aggr-function/m-p/610145#M225190 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>For one of the selections in the UI the below expression throws two values. How this is possible. Please explain! I'm not able to understand it.</P><P>aggr(&nbsp; if($(vXYZ)&nbsp; &gt;&nbsp; $(vABC),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (pow(10,floor(LOG10($(vXYZ))))),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (pow(10,floor(LOG10($(vABC))))))</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,Business,Business_Unit)</P></BODY></HTML> Mon, 07 Apr 2014 12:27:18 GMT https://community.qlik.com/t5/QlikView/Help-in-aggr-function/m-p/610145#M225190 qlikviewforum 2014-04-07T12:27:18Z Re: Help in aggr function! https://community.qlik.com/t5/QlikView/Help-in-aggr-function/m-p/610146#M225191 <HTML><HEAD></HEAD><BODY><P>this expression </P><P>calculate the result for each unique instance of Business and Business_Unit</P><P>and create a list of values for each unique value</P><P></P><P>so you should get a result for each unique instance </P></BODY></HTML> Mon, 07 Apr 2014 12:42:34 GMT https://community.qlik.com/t5/QlikView/Help-in-aggr-function/m-p/610146#M225191 lironbaram 2014-04-07T12:42:34Z