calculation of brand and site level inventory

[bushpalaamarnat]

Hi all,

I need help in how to project the data in qlikview. the objective is to show % of Site Net Inventory

following is total inventory by site:

Site	Net Inventory
UK	1000
FR	200
PO	110
CA	2400
US	250
SP	1900

Following is the total inventory by brand per site

Brand- Site	Net Inventory
Brand A - UK	190
Brand B - UK	60
Brand C - UK	90
Brand D - UK	40
Brand A - FR	12
Brand B - FR	40
Brand C - FR	19
Brand D - FR	31

[Anil_Babu_Samineni]

What are you trying to get using these tables?

Perhaps this Avg(TOTAL <site> [Net Inventory])

[bushpalaamarnat]

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.

[Anil_Babu_Samineni]

What is your input table and what is your output table?

[bushpalaamarnat]

Raw Data Input	Calculation for site		% of Brand - Site
Brand	Site	Net Inventory	Site	Total	Brand- Site	Net Inventory	%
Brand A	UK	190	UK	380	Brand A - UK	190	50%
Brand B	UK	60	FR	202	Brand C - UK	90	24%
Brand C	UK	90	Brand B - FR	40	20%
Brand D	UK	40	Brand B - UK	60	16%
Brand A	FR	12	Brand D - FR	31	15%
Brand B	FR	40	Brand D - UK	40	11%
Brand C	FR	19	Brand C - FR	19	9%
Brand D	FR	31	Brand A - FR	12	6%

[bushpalaamarnat]

Raw Data Input
Brand	Site	Net Inventory
Brand A	UK	190
Brand B	UK	60
Brand C	UK	90
Brand D	UK	40
Brand A	FR	12
Brand B	FR	40
Brand C	FR	19
Brand D	FR	31

Calculation for site
Site	Total
UK	380
FR	202

Final Out put

% of Brand - Site
Brand- Site	Net Inventory	%
Brand A - UK	190	50%
Brand C - UK	90	24%
Brand B - FR	40	20%
Brand B - UK	60	16%
Brand D - FR	31	15%
Brand D - UK	40	11%
Brand C - FR	19	9%
Brand A - FR	12	6%

[Anil_Babu_Samineni]

try to create table like

Dimension - Brand & ' - ' & site

Expressions are

Sum([Net Inventory])

Sum(Net Inventory]) // And enable Relative option to see?