Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create table Material Movement

Dear All master qlik,

Yesterday i've been asking and already got answered. But my boss said that the table should be more complicated than i asked yesterday.

So this is the table of raw data :

        

PTEstateDateMaterialMaterial_DescMaterial_Grp_DescTotal_Receipt_QtyTotal_Receipt_ValueTotal_Issue_QtyTotal_Issue_Value
AA101/08/201310000018BORATEFertililizer294,002.099.930,00-147,00-1.060.789,00
AA101/09/201310000018BORATEFertililizer11,6482.935.000,00-5,82-41.467.500,00
AA101/10/201310000018BORATEFertililizer0,000,00-1,77-12.615.932,00
AA201/08/201310000018BORATEFertililizer24,35173.546.195,00-12,17-86.890.874,00
AA201/09/201310000018BORATEFertililizer2,8620.368.230,00-9,63-68.597.080,00
AA201/10/201310000018BORATEFertililizer0,000,00-210,00-1.494.917,00

and from the table row data like above, i must create this kind of table :

          

PTEstateDateMaterialMaterial_DescMaterial_Grp_DescStart_QtyStart_ValueTotal_Receipt_QtyTotal_Receipt_ValueTotal_Issue_QtyTotal_Issue_ValueEnd_QtyEnd_Value
AA101/08/201310000018BORATEFertililizer00294,002.099.930,00-147,00-1.060.789,00147,001.039.141,00
AA101/09/201310000018BORATEFertililizer147,001.039.141,0011,6482.935.000,00-5,82-41.467.500,00152,8242.506.641,00
AA101/10/201310000018BORATEFertililizer152,8242.506.641,000,000,00-1,77-12.615.932,00151,0529.890.709,00
AA201/08/201310000018BORATEFertililizer0,000,0024,35173.546.195,00-12,17-86.890.874,0012,1786.655.321,00
AA201/09/201310000018BORATEFertililizer12,1786.655.321,002,8620.368.230,00-9,63-68.597.080,005,4038.426.471,00
AA201/10/201310000018BORATEFertililizer5,4038.426.471,000,000,00-210,00-1.494.917,00-204,6036.931.554,00

Please help me to create this above tabel, i need to add start_qty,start_value, end_qty, and end_value to the raw table.

So many thanks for the answer.

Regard's,

Hadi

0 Replies