topic Re: Aggregate ceiled rows in QlikView https://community.qlik.com/t5/QlikView/Aggregate-ceiled-rows/m-p/449238#M1157952 <HTML><HEAD></HEAD><BODY><P>You need to put the ceil inside the sum:</P><P>sum(ceil(pcs/[pcs per pallet]))</P></BODY></HTML> Thu, 21 Feb 2013 14:58:52 GMT Gysbert_Wassenaar 2013-02-21T14:58:52Z Aggregate ceiled rows https://community.qlik.com/t5/QlikView/Aggregate-ceiled-rows/m-p/449236#M1157950 <HTML><HEAD></HEAD><BODY><P>I have a table with the following dimensions:</P><P></P><P>* Article</P><P>* Receipt date</P><P>* # pcs</P><P>* # pcs per pallet</P><P></P><P>And the following calculated expression</P><P></P><P>* (ceil(sum(# pcs/ # pcs per pallet) to calculate the rounded # pallets to be received. </P><P></P><P>This works fine, but in another table I want to calculate the same, but summed per date:</P><P></P><P>Dimension:</P><P></P><P>* Receipt date</P><P></P><P>And the same following calculated expression, but then aggregated as in the first table. Otherwise the total # pallets is calculated over the (total #pcs/total #pcs per pallet) - here you will get a lower number of pallets. </P><P></P><P>How can I use the agg and the ceil?</P></BODY></HTML> Tue, 19 Feb 2013 12:31:45 GMT https://community.qlik.com/t5/QlikView/Aggregate-ceiled-rows/m-p/449236#M1157950 2013-02-19T12:31:45Z Re: Aggregate ceiled rows https://community.qlik.com/t5/QlikView/Aggregate-ceiled-rows/m-p/449237#M1157951 <HTML><HEAD></HEAD><BODY><P>See example</P></BODY></HTML> Thu, 21 Feb 2013 14:33:56 GMT https://community.qlik.com/t5/QlikView/Aggregate-ceiled-rows/m-p/449237#M1157951 2013-02-21T14:33:56Z Re: Aggregate ceiled rows https://community.qlik.com/t5/QlikView/Aggregate-ceiled-rows/m-p/449238#M1157952 <HTML><HEAD></HEAD><BODY><P>You need to put the ceil inside the sum:</P><P>sum(ceil(pcs/[pcs per pallet]))</P></BODY></HTML> Thu, 21 Feb 2013 14:58:52 GMT https://community.qlik.com/t5/QlikView/Aggregate-ceiled-rows/m-p/449238#M1157952 Gysbert_Wassenaar 2013-02-21T14:58:52Z