topic Advice on ABC stock analysis in QlikView https://community.qlik.com/t5/QlikView/Advice-on-ABC-stock-analysis/m-p/200076#M58745 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need advice on the following topic, see table descriptions below.<BR /><BR />The idea is to be able to select a date (from the mastercalendar) and an article, so that te application shows the corresponding costprice and numbers in stock.</P><P>In the COSTPRICE table the date is defined as a range. The STOCK table however contains only the mutation-dates, with the number_in_stock being the actual number.</P><P>Because the tables COSTPRICES and STOCKS both contain the column ART_ID, I got a circular reference in my datamodel.</P><P>In the end, I would like to be able to do an ABC analysis based on costprice and number_in_stock.</P><P>What is best practice in a situation like this?</P><P>Thanks in advance!</P><P>Marco</P><P>-------------------------------------------------------------------------------------------------------------------------------------------------</P><P>MasterCalendar:<BR /> date</P><P>Articles:<BR /> art_id<BR /> description<BR /><BR />CostPrices:<BR /> art_id<BR /> start_date<BR /> end_date<BR /> price</P><P>Stocks:<BR /> art_id<BR /> date<BR /> number_in_stock</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 14 Sep 2010 14:24:12 GMT 2010-09-14T14:24:12Z Advice on ABC stock analysis https://community.qlik.com/t5/QlikView/Advice-on-ABC-stock-analysis/m-p/200076#M58745 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need advice on the following topic, see table descriptions below.<BR /><BR />The idea is to be able to select a date (from the mastercalendar) and an article, so that te application shows the corresponding costprice and numbers in stock.</P><P>In the COSTPRICE table the date is defined as a range. The STOCK table however contains only the mutation-dates, with the number_in_stock being the actual number.</P><P>Because the tables COSTPRICES and STOCKS both contain the column ART_ID, I got a circular reference in my datamodel.</P><P>In the end, I would like to be able to do an ABC analysis based on costprice and number_in_stock.</P><P>What is best practice in a situation like this?</P><P>Thanks in advance!</P><P>Marco</P><P>-------------------------------------------------------------------------------------------------------------------------------------------------</P><P>MasterCalendar:<BR /> date</P><P>Articles:<BR /> art_id<BR /> description<BR /><BR />CostPrices:<BR /> art_id<BR /> start_date<BR /> end_date<BR /> price</P><P>Stocks:<BR /> art_id<BR /> date<BR /> number_in_stock</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 14 Sep 2010 14:24:12 GMT https://community.qlik.com/t5/QlikView/Advice-on-ABC-stock-analysis/m-p/200076#M58745 2010-09-14T14:24:12Z