topic daily inventory (set analysis??) in QlikView https://community.qlik.com/t5/QlikView/daily-inventory-set-analysis/m-p/295589#M109703 <HTML><HEAD></HEAD><BODY><P> Hello, I hope anybody can solve my problem. I wanna show the inventory with day as dimension (it should always show every day of the selected month, not only the days where s.th. has changed. so usually I see 30 or 31 days on the x-axes). To calculate the inventory i need a field "remaining quantity" from table entries + the field quantity from the table outs. The problem is, if I choose day as dimension and just some the amounts it shows me daily changes, but it need to start from the earliest date until the 30 different days of the selected month. full accumulation doesn´t seem to be a solution. is it possible to do this anyway?</P></BODY></HTML> Tue, 13 Dec 2011 08:21:46 GMT michael_maeuser 2011-12-13T08:21:46Z daily inventory (set analysis??) https://community.qlik.com/t5/QlikView/daily-inventory-set-analysis/m-p/295589#M109703 <HTML><HEAD></HEAD><BODY><P> Hello, I hope anybody can solve my problem. I wanna show the inventory with day as dimension (it should always show every day of the selected month, not only the days where s.th. has changed. so usually I see 30 or 31 days on the x-axes). To calculate the inventory i need a field "remaining quantity" from table entries + the field quantity from the table outs. The problem is, if I choose day as dimension and just some the amounts it shows me daily changes, but it need to start from the earliest date until the 30 different days of the selected month. full accumulation doesn´t seem to be a solution. is it possible to do this anyway?</P></BODY></HTML> Tue, 13 Dec 2011 08:21:46 GMT https://community.qlik.com/t5/QlikView/daily-inventory-set-analysis/m-p/295589#M109703 michael_maeuser 2011-12-13T08:21:46Z daily inventory (set analysis??) https://community.qlik.com/t5/QlikView/daily-inventory-set-analysis/m-p/295590#M109704 <HTML><HEAD></HEAD><BODY><P>Maybe it's doable with an expression, but wouldn't it be easier to create a field in the script calculating the daily inventory? Would this be consistent with your requirements? </P><P></P><P>If you post some simple sample data, maybe as INLINE table, I guess someone here in the forum might come up with a solution pretty fast.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Tue, 13 Dec 2011 10:23:13 GMT https://community.qlik.com/t5/QlikView/daily-inventory-set-analysis/m-p/295590#M109704 swuehl 2011-12-13T10:23:13Z