Aggr function is not working

[Qliksense_Neuling]

Hello Community

I have problem with this function

Data:

Project6   (Produkt)Group   (NETWR) 

I need the % value Project6 & Group NETWR vs Project6 NETWR

aggr(Sum([ZSSALES.NETWR]),[%Project6 ],[ZSSALES.Group])/sum(aggr(Sum(total[ZSSALES.NETWR]),[ZSSALES.Group],[%Project6 ]))

In my result list i get % by Group  only over all projects, not by project.

thanks in advance for your help

Br 

Maik

[rubenmarin]

Hi, where you want to show this? If in a table wich ones are dimensions?

If you have Project6 and Group as dimensions you can use: Sum([ZSSALES.NETWR])/Sum(TOTAL <[ZSSALES.Group]> [ZSSALES.NETWR])

Another possible solution is Sum(Aggr(Sum([ZSSALES.NETWR])/Sum(TOTAL <[ZSSALES.Group]> [ZSSALES.NETWR]), [ZSSALES.Group], [%Project6 ]))

[Qliksense_Neuling · Accepted solution]

Hello Rubenmarin,

thanks for your feedback. the result is showing in a table

Project6     Group   NETWR      NETWRvsProjectNetWR

I have modify your proposal and it works fine

Sum(Aggr(Sum([ZSSALES.NETWR])/Sum(TOTAL <[%Projekt6]> [ZSSALES.NETWR]), [%Projekt6],[ZSSALES.Group]))

thanks a lot and have a nice weekend

Br

Maik