topic Re: Problem in Expression .. in QlikView https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913356#M529765 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try Sum(Aggr(sum(L2AMID_VALUE_USD),L2AMID))</P><P></P><P>regards</P></BODY></HTML> Fri, 24 Jul 2015 05:35:19 GMT PrashantSangle 2015-07-24T05:35:19Z Problem in Expression .. https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913355#M529764 <HTML><HEAD></HEAD><BODY><P>Hi Frnz,</P><P>I was stuck at small expression. I need to show sum(L2AMID_VALUE_USD) in the basis of L2AMID field. I have used in AGGR in expression. But it is not working.</P><P>Please help to find solution. Please find the attached QVW.</P><P>L2AMID ===&gt; Account ids</P><P><SPAN style="font-size: 13.3333330154419px;">L2AMID_VALUE_USD ====&gt; Measure in USD$</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P></BODY></HTML> Fri, 24 Jul 2015 05:26:09 GMT https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913355#M529764 2015-07-24T05:26:09Z Re: Problem in Expression .. https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913356#M529765 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try Sum(Aggr(sum(L2AMID_VALUE_USD),L2AMID))</P><P></P><P>regards</P></BODY></HTML> Fri, 24 Jul 2015 05:35:19 GMT https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913356#M529765 PrashantSangle 2015-07-24T05:35:19Z Re: Problem in Expression .. https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913357#M529766 <HTML><HEAD></HEAD><BODY><P>Hii</P><P></P><P>PFA</P><P>Is that you want</P><P></P><P>Thanks</P></BODY></HTML> Fri, 24 Jul 2015 05:42:10 GMT https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913357#M529766 prajapatiamar38 2015-07-24T05:42:10Z Re: Problem in Expression .. https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913358#M529767 <HTML><HEAD></HEAD><BODY><P>Hi Max,</P><P>Thanks for your reply. It is showing wrong totals. It is not working properly</P></BODY></HTML> Fri, 24 Jul 2015 05:42:52 GMT https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913358#M529767 2015-07-24T05:42:52Z Re: Problem in Expression .. https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913359#M529768 <HTML><HEAD></HEAD><BODY><P>Hi - I could see two dimesions are already in use. While solution given by max dreamer should work, could you please let us know what is the expected result?</P></BODY></HTML> Fri, 24 Jul 2015 07:54:25 GMT https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913359#M529768 2015-07-24T07:54:25Z Re: Problem in Expression .. https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913360#M529769 <HTML><HEAD></HEAD><BODY><P>sorry..It is working..Thanks Max</P></BODY></HTML> Fri, 24 Jul 2015 07:57:56 GMT https://community.qlik.com/t5/QlikView/Problem-in-Expression/m-p/913360#M529769 2015-07-24T07:57:56Z