https://community.qlik.com/t5/QlikView/How-to-Vlookup-with-sum/m-p/1905315#M1217888 <P>Hi Everyone , i have in my data model the following tables:</P> <UL> <LI>Sales order table</LI> <LI>Inventory Table</LI> </UL> <P>I created a chart with informatino about Order Number and item number. I would like to see in the same chart, the quantity on stock about an item (Coming from table Inventory). How this can be done?</P> <P>&nbsp;</P> <P>I would like not to left-join, since i would like to have a varibale with a date, to be able to filter the quantity on stock based on the expiration date. So if i set varibale as 10/03/2022, the quantity that should appear on chart should it be related just for items expiring after that date.</P> <P>What's the best solution to meet this requirement?<BR />Thank you!</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qlikviewaf_0-1647346370574.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74496iFB850DCFAC8F21D1/image-size/medium?v=v2&amp;px=400" role="button" title="qlikviewaf_0-1647346370574.png" alt="qlikviewaf_0-1647346370574.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 15 Mar 2022 12:14:32 GMT qlikviewaf 2022-03-15T12:14:32Z https://community.qlik.com/t5/QlikView/How-to-Vlookup-with-sum/m-p/1905315#M1217888 <P>Hi Everyone , i have in my data model the following tables:</P> <UL> <LI>Sales order table</LI> <LI>Inventory Table</LI> </UL> <P>I created a chart with informatino about Order Number and item number. I would like to see in the same chart, the quantity on stock about an item (Coming from table Inventory). How this can be done?</P> <P>&nbsp;</P> <P>I would like not to left-join, since i would like to have a varibale with a date, to be able to filter the quantity on stock based on the expiration date. So if i set varibale as 10/03/2022, the quantity that should appear on chart should it be related just for items expiring after that date.</P> <P>What's the best solution to meet this requirement?<BR />Thank you!</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qlikviewaf_0-1647346370574.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/74496iFB850DCFAC8F21D1/image-size/medium?v=v2&amp;px=400" role="button" title="qlikviewaf_0-1647346370574.png" alt="qlikviewaf_0-1647346370574.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 15 Mar 2022 12:14:32 GMT https://community.qlik.com/t5/QlikView/How-to-Vlookup-with-sum/m-p/1905315#M1217888 qlikviewaf 2022-03-15T12:14:32Z