topic Calculate actual Inventory in QlikView https://community.qlik.com/t5/QlikView/Calculate-actual-Inventory/m-p/812216#M471881 <HTML><HEAD></HEAD><BODY><P>Dear Qlikviewers,</P><P></P><P>In the table below you will the data that i've to calculate the actual inventory each day. </P><P></P><P>How to calculate the actual amount? It should sum the highest SerialNr per WarehouseNr. In this case SerialNr 4,5 and 3. Who can help me out? The explanation what the columns mean see below</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78234_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P style="font-size: 13.3333330154419px;">Artikelnr=Unique number</P><P style="font-size: 13.3333330154419px;">Datum=date</P><P style="font-size: 13.3333330154419px;">Serialnr=Unique number for every day</P><P style="font-size: 13.3333330154419px;">WarehouseNr=Warehouse number for every record</P><P style="font-size: 13.3333330154419px;">WH1/WH2/WH3=every warehouse has it own colomn</P></BODY></HTML> Mon, 16 Feb 2015 13:22:33 GMT tomhovens 2015-02-16T13:22:33Z Calculate actual Inventory https://community.qlik.com/t5/QlikView/Calculate-actual-Inventory/m-p/812216#M471881 <HTML><HEAD></HEAD><BODY><P>Dear Qlikviewers,</P><P></P><P>In the table below you will the data that i've to calculate the actual inventory each day. </P><P></P><P>How to calculate the actual amount? It should sum the highest SerialNr per WarehouseNr. In this case SerialNr 4,5 and 3. Who can help me out? The explanation what the columns mean see below</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/78234_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P style="font-size: 13.3333330154419px;">Artikelnr=Unique number</P><P style="font-size: 13.3333330154419px;">Datum=date</P><P style="font-size: 13.3333330154419px;">Serialnr=Unique number for every day</P><P style="font-size: 13.3333330154419px;">WarehouseNr=Warehouse number for every record</P><P style="font-size: 13.3333330154419px;">WH1/WH2/WH3=every warehouse has it own colomn</P></BODY></HTML> Mon, 16 Feb 2015 13:22:33 GMT https://community.qlik.com/t5/QlikView/Calculate-actual-Inventory/m-p/812216#M471881 tomhovens 2015-02-16T13:22:33Z