topic sum or aggr in QlikView

sum or aggr

Tue, 26 Oct 2010 17:12:44 GMT

I have to determine the % total annual sales for each country

sample:

Country year 2010 % year 2009 % year 2008

A 100 33,33 500 50 ..........

B 200 66,66 500 50 ..............

country is a dynamic group by and the user can change selection

user can change temporal vision to split in year/month

I try to use this formula aggr(SUM([Sales]), [Country],[Year]) but is static

sum(total [Sales]) is wrong

which formula should I use?

Thanks

sum or aggr

marcel_olmo — Tue, 26 Oct 2010 17:20:09 GMT

Hey train,

everything seems to be fine.

Try to do the aggregate directly with the name of the dynamic group.

aggr(SUM([Sales]), NameOfYourDynamicGroup)

I've tried something recently with a hierarchical group.

In QV9, it will show you this is a bad field name, but you don't have to worry, they don't recognize it as a variable, but it doesn't mean this is not correct.

You can find more info in my bug report :

http://community.qlik.com/forums/p/35970/140928.aspx#140928

I hope it will helps !!