topic Re: calculation of brand and site level inventory in QlikView https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457752#M435515 <HTML><HEAD></HEAD><BODY><P>What is your input table and what is your output table?</P></BODY></HTML> Wed, 03 Jan 2018 07:33:53 GMT Anil_Babu_Samineni 2018-01-03T07:33:53Z calculation of brand and site level inventory https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457749#M435512 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>I need help in how to project the data in qlikview. the objective is to show % of Site Net Inventory </P><P></P><P>following is total inventory by site:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="266"><TBODY><TR><TD height="20" width="169">Site</TD><TD width="97">Net Inventory </TD></TR><TR><TD height="20">UK</TD><TD align="right" class="xl65">1000</TD></TR><TR><TD height="20">FR</TD><TD align="right" class="xl65" style="border-top: none;">200</TD></TR><TR><TD height="20">PO</TD><TD align="right" class="xl65" style="border-top: none;">110</TD></TR><TR><TD height="20">CA</TD><TD align="right" class="xl65" style="border-top: none;">2400</TD></TR><TR><TD height="20">US</TD><TD align="right" class="xl65" style="border-top: none;">250</TD></TR><TR><TD height="20">SP</TD><TD align="right" class="xl65" style="border-top: none;"><P>1900</P></TD></TR></TBODY></TABLE><P></P><P>Following is the total inventory by brand per site</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="177"><TBODY><TR><TD height="20" width="83">Brand- Site</TD><TD width="94">Net Inventory</TD></TR><TR><TD height="20">Brand A - UK</TD><TD align="right">190</TD></TR><TR><TD height="20">Brand B - UK</TD><TD align="right">60</TD></TR><TR><TD height="20">Brand C - UK</TD><TD align="right">90</TD></TR><TR><TD height="20">Brand D - UK</TD><TD align="right">40</TD></TR><TR><TD height="20">Brand A - FR</TD><TD align="right">12</TD></TR><TR><TD height="20">Brand B - FR</TD><TD align="right">40</TD></TR><TR><TD height="20">Brand C - FR</TD><TD align="right">19</TD></TR><TR><TD height="20">Brand D - FR</TD><TD align="right">31</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 03 Jan 2018 03:36:13 GMT https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457749#M435512 bushpalaamarnat 2018-01-03T03:36:13Z Re: calculation of brand and site level inventory https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457750#M435513 <HTML><HEAD></HEAD><BODY><P>What are you trying to get using these tables?</P><P>Perhaps this <STRONG>Avg(TOTAL &lt;site&gt; [</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Net Inventory])</STRONG></SPAN></P></BODY></HTML> Wed, 03 Jan 2018 03:42:38 GMT https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457750#M435513 Anil_Babu_Samineni 2018-01-03T03:42:38Z Re: calculation of brand and site level inventory https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457751#M435514 <HTML><HEAD></HEAD><BODY><P>perhaps i was not clear, i want to get the data as in the tables from raw data, the projection needs to be in that format and calculations.</P></BODY></HTML> Wed, 03 Jan 2018 07:31:06 GMT https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457751#M435514 bushpalaamarnat 2018-01-03T07:31:06Z Re: calculation of brand and site level inventory https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457752#M435515 <HTML><HEAD></HEAD><BODY><P>What is your input table and what is your output table?</P></BODY></HTML> Wed, 03 Jan 2018 07:33:53 GMT https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457752#M435515 Anil_Babu_Samineni 2018-01-03T07:33:53Z Re: calculation of brand and site level inventory https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457753#M435516 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="833"><TBODY><TR><TD height="20" width="101">Raw Data Input</TD><TD colspan="2" width="128">Calculation for site</TD><TD width="109">% of Brand - Site</TD></TR><TR><TD height="20">Brand</TD><TD>Site</TD><TD>Net Inventory</TD><TD>Site</TD><TD>Total</TD><TD>Brand- Site</TD><TD>Net Inventory</TD><TD>%</TD></TR><TR><TD height="20">Brand A</TD><TD>UK</TD><TD align="right">190</TD><TD>UK</TD><TD align="right">380</TD><TD>Brand A - UK</TD><TD align="right">190</TD><TD align="right" class="xl65">50%</TD></TR><TR><TD height="20">Brand B</TD><TD>UK</TD><TD align="right">60</TD><TD>FR</TD><TD align="right">202</TD><TD>Brand C - UK</TD><TD align="right">90</TD><TD align="right" class="xl65">24%</TD></TR><TR><TD height="20">Brand C</TD><TD>UK</TD><TD align="right">90</TD><TD>Brand B - FR</TD><TD align="right">40</TD><TD align="right" class="xl65">20%</TD></TR><TR><TD height="20">Brand D</TD><TD>UK</TD><TD align="right">40</TD><TD>Brand B - UK</TD><TD align="right">60</TD><TD align="right" class="xl65">16%</TD></TR><TR><TD height="20">Brand A</TD><TD>FR</TD><TD align="right">12</TD><TD>Brand D - FR</TD><TD align="right">31</TD><TD align="right" class="xl65">15%</TD></TR><TR><TD height="20">Brand B</TD><TD>FR</TD><TD align="right">40</TD><TD>Brand D - UK</TD><TD align="right">40</TD><TD align="right" class="xl65">11%</TD></TR><TR><TD height="20">Brand C</TD><TD>FR</TD><TD align="right">19</TD><TD>Brand C - FR</TD><TD align="right">19</TD><TD align="right" class="xl65">9%</TD></TR><TR><TD height="20">Brand D</TD><TD>FR</TD><TD align="right">31</TD><TD>Brand A - FR</TD><TD align="right">12</TD><TD align="right" class="xl65">6%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 03 Jan 2018 07:56:10 GMT https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457753#M435516 bushpalaamarnat 2018-01-03T07:56:10Z Re: calculation of brand and site level inventory https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457754#M435517 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 278px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Raw Data Input</TH></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Brand</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Site</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Net Inventory</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Brand A</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">UK</TD><TD align="right" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">190</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Brand B</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">UK</TD><TD align="right" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">60</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Brand C</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">UK</TD><TD align="right" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">90</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Brand D</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">UK</TD><TD align="right" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">40</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Brand A</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FR</TD><TD align="right" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">12</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Brand B</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FR</TD><TD align="right" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">40</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Brand C</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FR</TD><TD align="right" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">19</TD></TR><TR><TD height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Brand D</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FR</TD><TD align="right" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">31</TD></TR></TBODY></TABLE><P></P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD colspan="2" height="20" width="128">Calculation for site</TD></TR><TR><TD height="20">Site</TD><TD>Total</TD></TR><TR><TD height="20">UK</TD><TD align="right">380</TD></TR><TR><TD height="20">FR</TD><TD align="right">202</TD></TR></TBODY></TABLE><P></P><P></P><P>Final Out put</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="235"><TBODY><TR><TD height="20" width="109">% of Brand - Site</TD></TR><TR><TD height="20">Brand- Site</TD><TD>Net Inventory</TD><TD>%</TD></TR><TR><TD height="20">Brand A - UK</TD><TD align="right">190</TD><TD align="right" class="xl65">50%</TD></TR><TR><TD height="20">Brand C - UK</TD><TD align="right">90</TD><TD align="right" class="xl65">24%</TD></TR><TR><TD height="20">Brand B - FR</TD><TD align="right">40</TD><TD align="right" class="xl65">20%</TD></TR><TR><TD height="20">Brand B - UK</TD><TD align="right">60</TD><TD align="right" class="xl65">16%</TD></TR><TR><TD height="20">Brand D - FR</TD><TD align="right">31</TD><TD align="right" class="xl65">15%</TD></TR><TR><TD height="20">Brand D - UK</TD><TD align="right">40</TD><TD align="right" class="xl65">11%</TD></TR><TR><TD height="20">Brand C - FR</TD><TD align="right">19</TD><TD align="right" class="xl65">9%</TD></TR><TR><TD height="20">Brand A - FR</TD><TD align="right">12</TD><TD align="right" class="xl65">6%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 03 Jan 2018 07:58:32 GMT https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457754#M435517 bushpalaamarnat 2018-01-03T07:58:32Z Re: calculation of brand and site level inventory https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457755#M435518 <HTML><HEAD></HEAD><BODY><P>try to create table like</P><P>Dimension - Brand &amp; ' - ' &amp; site</P><P>Expressions are</P><P>Sum([Net Inventory])</P><P>Sum(Net Inventory]) // And enable Relative option to see? </P></BODY></HTML> Wed, 03 Jan 2018 08:50:43 GMT https://community.qlik.com/t5/QlikView/calculation-of-brand-and-site-level-inventory/m-p/1457755#M435518 Anil_Babu_Samineni 2018-01-03T08:50:43Z