topic Re: Question on aggr function as facing issue in calculations in QlikView

Question on aggr function as facing issue in calculations

bushpalaamarnat — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Question on aggr function as facing issue in calculations

tresB — Wed, 03 Jan 2018 08:27:56 GMT

Could you post your sample qvw explaining expected output?

Re: Question on aggr function as facing issue in calculations

bushpalaamarnat — Wed, 03 Jan 2018 08:55:51 GMT

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

Re: Question on aggr function as facing issue in calculations

tresB — Wed, 03 Jan 2018 09:00:27 GMT

Check this:Uploading a Sample

Re: Question on aggr function as facing issue in calculations

bushpalaamarnat — Wed, 03 Jan 2018 09:07:40 GMT

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

Re: Question on aggr function as facing issue in calculations

Anil_Babu_Samineni — Wed, 03 Jan 2018 09:18:36 GMT

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

Re: Question on aggr function as facing issue in calculations

tresB — Wed, 03 Jan 2018 09:20:58 GMT

Try exp:

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

Re: Question on aggr function as facing issue in calculations

bushpalaamarnat — Wed, 03 Jan 2018 10:36:59 GMT

Perfect! thank you it is great help!

Re: Question on aggr function as facing issue in calculations

mdmukramali — Wed, 03 Jan 2018 11:19:18 GMT

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.

Re: Question on aggr function as facing issue in calculations

bushpalaamarnat — Thu, 04 Jan 2018 09:25:45 GMT

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.

Re: Question on aggr function as facing issue in calculations

tresB — Thu, 04 Jan 2018 09:32:50 GMT

Open this thread from the browser directly (and not from Inbox), then:Qlik Community Tip: Marking Replies as Correct or Helpful