Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 !!