topic Re: Aggregation Problem in Expression in QlikView https://community.qlik.com/t5/QlikView/Aggregation-Problem-in-Expression/m-p/936125#M323171 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97484_Capture.PNG" style="height: auto;" /></P><P>Hope this data helps !! Expression i wrote here for warehouse is same as i mentioned in question. Now i want this expression to be grouped by subdivision via total qualifier or aggr if there's a way to do it. When i am using aggr outside of whole expression it is giving null values. Any suggestions would be appreciated.</P></BODY></HTML> Mon, 31 Aug 2015 15:51:47 GMT 2015-08-31T15:51:47Z Aggregation Problem in Expression https://community.qlik.com/t5/QlikView/Aggregation-Problem-in-Expression/m-p/936123#M323169 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Hey all,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I am stuck at a problem where we have a following expression in a straight table. Now i want to use this expression in another expression but grouped by a dimension named subdivsion. Help us out in this matter:<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">expression :&nbsp;&nbsp; (WareHouseExpense1_Sender*sum(Conversion*[tr_Qty Sold]))/sum(total&lt;WHS_Sender_Key&gt;Conversion*[tr_Qty Sold]))</SPAN></P></BODY></HTML> Mon, 31 Aug 2015 08:53:04 GMT https://community.qlik.com/t5/QlikView/Aggregation-Problem-in-Expression/m-p/936123#M323169 2015-08-31T08:53:04Z Re: Aggregation Problem in Expression https://community.qlik.com/t5/QlikView/Aggregation-Problem-in-Expression/m-p/936124#M323170 <HTML><HEAD></HEAD><BODY><P>Would you be able to share few lines of data?</P></BODY></HTML> Mon, 31 Aug 2015 14:10:12 GMT https://community.qlik.com/t5/QlikView/Aggregation-Problem-in-Expression/m-p/936124#M323170 sunny_talwar 2015-08-31T14:10:12Z Re: Aggregation Problem in Expression https://community.qlik.com/t5/QlikView/Aggregation-Problem-in-Expression/m-p/936125#M323171 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97484_Capture.PNG" style="height: auto;" /></P><P>Hope this data helps !! Expression i wrote here for warehouse is same as i mentioned in question. Now i want this expression to be grouped by subdivision via total qualifier or aggr if there's a way to do it. When i am using aggr outside of whole expression it is giving null values. Any suggestions would be appreciated.</P></BODY></HTML> Mon, 31 Aug 2015 15:51:47 GMT https://community.qlik.com/t5/QlikView/Aggregation-Problem-in-Expression/m-p/936125#M323171 2015-08-31T15:51:47Z