topic Update week Inventory for missing Week in QlikView https://community.qlik.com/t5/QlikView/Update-week-Inventory-for-missing-Week/m-p/79149#M772037 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I have day wise inventory where some partners are not reporting regularly.. I want to pick <SPAN style="font-size: 13.3333px;">latest reported </SPAN>week opening inventory as of Monday and name them as&nbsp; Week1, Week2, Week3 so on for a Quarter. Inventory_date and Partner_Name is key.</P><P></P><P>I tried doing inner join <SPAN style="font-size: 13.3333px;">Max(</SPAN><SPAN style="font-size: 13.3333px;">Inventory_date)</SPAN> group by <SPAN style="font-size: 13.3333px;">Partner_Name.. </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Problem here is some partners have not reported inventory for whole week.</SPAN></P><P></P><P>How can i achieve this.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT specter21 2020-11-25T16:16:04Z Update week Inventory for missing Week https://community.qlik.com/t5/QlikView/Update-week-Inventory-for-missing-Week/m-p/79149#M772037 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I have day wise inventory where some partners are not reporting regularly.. I want to pick <SPAN style="font-size: 13.3333px;">latest reported </SPAN>week opening inventory as of Monday and name them as&nbsp; Week1, Week2, Week3 so on for a Quarter. Inventory_date and Partner_Name is key.</P><P></P><P>I tried doing inner join <SPAN style="font-size: 13.3333px;">Max(</SPAN><SPAN style="font-size: 13.3333px;">Inventory_date)</SPAN> group by <SPAN style="font-size: 13.3333px;">Partner_Name.. </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Problem here is some partners have not reported inventory for whole week.</SPAN></P><P></P><P>How can i achieve this.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Update-week-Inventory-for-missing-Week/m-p/79149#M772037 specter21 2020-11-25T16:16:04Z