topic Re: Calculate Inventory Days in QlikView https://community.qlik.com/t5/QlikView/Calculate-Inventory-Days/m-p/1383695#M800120 <HTML><HEAD></HEAD><BODY><P>Like this??</P><P>Aggr(Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> Inventory Days </SPAN>),<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Dept </SPAN>)</P></BODY></HTML> Tue, 28 Nov 2017 07:19:13 GMT prma7799 2017-11-28T07:19:13Z Calculate Inventory Days https://community.qlik.com/t5/QlikView/Calculate-Inventory-Days/m-p/1383694#M800119 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have Inventory Data Sheet with following Columns - </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="470"><TBODY><TR><TD class="xl63" height="20" width="36">Date</TD><TD class="xl63" style="border-left: none;" width="72">Metal</TD><TD class="xl63" style="border-left: none;" width="146">Inv</TD><TD class="xl63" style="border-left: none;" width="146">Dept</TD><TD class="xl63" style="border-left: none;" width="70">Co.</TD></TR></TBODY></TABLE><P></P><P>I have Sales Data sheet with following Columns - </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="400"><TBODY><TR><TD class="xl65" height="20" width="36">Date</TD><TD class="xl65" style="border-left: none;" width="72">Metal</TD><TD class="xl65" style="border-left: none;" width="146">Sales</TD><TD class="xl65" style="border-left: none;" width="146">Co.</TD></TR></TBODY></TABLE><P></P><P>My Date, Metal and Co is linked</P><P></P><P>Now I want to calculate Dept wise Inventory Days&nbsp; </P><P></P><P>(Avg Dept Wise inventory )/(Avg Sales)</P><P></P><P>Please help how to calculate</P><P></P><P><SPAN style="font-size: 10pt;">Thanks </SPAN></P><P><SPAN style="font-size: 10pt;">Vikas </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-Inventory-Days/m-p/1383694#M800119 vikas_nandanwar 2020-11-25T16:16:04Z Re: Calculate Inventory Days https://community.qlik.com/t5/QlikView/Calculate-Inventory-Days/m-p/1383695#M800120 <HTML><HEAD></HEAD><BODY><P>Like this??</P><P>Aggr(Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> Inventory Days </SPAN>),<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Dept </SPAN>)</P></BODY></HTML> Tue, 28 Nov 2017 07:19:13 GMT https://community.qlik.com/t5/QlikView/Calculate-Inventory-Days/m-p/1383695#M800120 prma7799 2017-11-28T07:19:13Z Re: Calculate Inventory Days https://community.qlik.com/t5/QlikView/Calculate-Inventory-Days/m-p/1383696#M800121 <HTML><HEAD></HEAD><BODY><P>Nope</P><P></P><P>It should be like</P><P></P><P>(Avg dept wise inventory)&nbsp; / (Dept Wise Sales)</P><P></P><P>I have Average Dept Wise inventory </P><P>But how to get dept wise sales</P></BODY></HTML> Tue, 28 Nov 2017 07:22:04 GMT https://community.qlik.com/t5/QlikView/Calculate-Inventory-Days/m-p/1383696#M800121 vikas_nandanwar 2017-11-28T07:22:04Z Re: Calculate Inventory Days https://community.qlik.com/t5/QlikView/Calculate-Inventory-Days/m-p/1383697#M800122 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Aggr(Avg(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> Inventory Days </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">),</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Dept </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">)</SPAN> / <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Aggr(sum(</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> Sale </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">),</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Dept </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">)</SPAN></SPAN></P></BODY></HTML> Tue, 28 Nov 2017 07:29:51 GMT https://community.qlik.com/t5/QlikView/Calculate-Inventory-Days/m-p/1383697#M800122 prma7799 2017-11-28T07:29:51Z