Question on aggr function as facing issue in calculations

[bushpalaamarnat]

I have used following formula

aggr(Sum([Net Inventory]),Brand_Site)

and

Sum(total <[Market 2]>[Net Inventory])

am trying to calculate (brand total per site/ total site)*100.

when am selecting dimension brand the calculation dont happen? if i select site the formula Sum(total <[Market 2]>[Net Inventory]) works and the other one does not. this is wise versa issue.

[tresesco]

Could you post your sample qvw explaining expected output?

[bushpalaamarnat]

how to attach the qvw, i can see an attach option?

[tresesco]

Check this:Uploading a Sample

[bushpalaamarnat]

Thank you for the information so far. attached a sample qvw for your reference. Kindly assist.

my final out put should be something like this

% 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%

and

Calculation for site
Site	Total
UK	380
FR	202

[Anil_Babu_Samineni]

Not sure, Why you created another thread https://community.qlik.com/message/1410229?et=watches.email.thread#1410229

[tresesco · Accepted solution]

Try exp:

Sum([Net Inventory])/Aggr(Sum(total <[Market 2]> [Net Inventory]),Brand_Site,[Market 2])

[bushpalaamarnat]

Perfect! thank you it is great help!

[mdmukramali]

Hi Neelima,

if it's solved your issue then please close the thread by selecting correct answer option

may be it will be helpful for others. bushpalaamarnath‌

Thanks,

Mukram.

[bushpalaamarnat]

I really want to do that, mean it. However in this chain i do not have that option to select. Is there a way to do that, kindly let me know.