topic Re: Caluculation per item with dimension year in QlikView https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331177#M122016 <HTML><HEAD></HEAD><BODY><P>I don't understand why item does not appear as a dimension in your per year table </P></BODY></HTML> Thu, 05 Jul 2012 15:57:32 GMT 2012-07-05T15:57:32Z Caluculation per item with dimension year https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331171#M122010 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have the following expression for my raw material:</P><P>=(Sum(Raw Material])/[Product.Lot Size]/Count( DISTINCT [Prod_ Order No_]))*Quantity</P><P>If I have item as dimension, it works fine. But now I want year as dimension. I tried it with aggr but I don´t get it to work correctly.</P><P>Thanks for helping!</P></BODY></HTML> Tue, 03 Jul 2012 09:30:09 GMT https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331171#M122010 michael_maeuser 2012-07-03T09:30:09Z Re: Caluculation per item with dimension year https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331172#M122011 <HTML><HEAD></HEAD><BODY><P>That's because you have several Product.Lot Size's and Quantity's for a year.</P><P>Not even working if you aggregate the whole thing over item and sum up the parts?</P><P></P><P>In that case maybe you can upload a small example?</P></BODY></HTML> Tue, 03 Jul 2012 09:36:34 GMT https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331172#M122011 Anonymous 2012-07-03T09:36:34Z Re: Caluculation per item with dimension year https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331173#M122012 <HTML><HEAD></HEAD><BODY><P>the lot size for one item is always the same (comes from item card). ok, it was sum(Quantity). But still i don´t get a result. i tried =(aggr(Sum(Raw Material]/[Product.Lot Size]), item)/aggr(Count( DISTINCT [Prod_ Order No_]), item))*aggr(sum(Quantity), item)</P><P> i´m also not sure how to put aggregate over item for the lotsize, since there is now sum or anything else.</P></BODY></HTML> Tue, 03 Jul 2012 14:31:55 GMT https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331173#M122012 michael_maeuser 2012-07-03T14:31:55Z Re: Caluculation per item with dimension year https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331174#M122013 <HTML><HEAD></HEAD><BODY><P>so now attached is a sample qvw. This issue is very important to me, so thanks for any help.</P></BODY></HTML> Thu, 05 Jul 2012 14:00:39 GMT https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331174#M122013 michael_maeuser 2012-07-05T14:00:39Z Re: Caluculation per item with dimension year https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331175#M122014 <HTML><HEAD></HEAD><BODY><P>Check your expression is correct or not?</P><P>see the attached sample</P></BODY></HTML> Thu, 05 Jul 2012 14:21:54 GMT https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331175#M122014 sivarajs 2012-07-05T14:21:54Z Re: Caluculation per item with dimension year https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331176#M122015 <HTML><HEAD></HEAD><BODY><P>no it´s incorrect. the lotsize comes from the itemcard and is not related to a date at all. next problem is even though my dimension is year, qlikview needs to execute the calculation per item and then show me the sum. so i probably need aggr function or s.th. like that. but i don´t know how to that exactly</P></BODY></HTML> Thu, 05 Jul 2012 14:38:15 GMT https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331176#M122015 michael_maeuser 2012-07-05T14:38:15Z Re: Caluculation per item with dimension year https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331177#M122016 <HTML><HEAD></HEAD><BODY><P>I don't understand why item does not appear as a dimension in your per year table </P></BODY></HTML> Thu, 05 Jul 2012 15:57:32 GMT https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331177#M122016 2012-07-05T15:57:32Z Re: Caluculation per item with dimension year https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331178#M122017 <HTML><HEAD></HEAD><BODY><P>because i want to show the total of rawmaterial costs per year</P></BODY></HTML> Fri, 06 Jul 2012 06:13:11 GMT https://community.qlik.com/t5/QlikView/Caluculation-per-item-with-dimension-year/m-p/331178#M122017 michael_maeuser 2012-07-06T06:13:11Z