Discussion board where members can get started with Qlik Sense.
Has anyone else had issues where total does not work within the Aggr function or have any ideas for a work around?
For example, Sum(Aggr(Avg(Total Amount) does not actually show the total amount.
Thank you !!
Can we have an example where it fails for you, I am not seeing anything wrong in that?
This expression will not give the the total
It will calculate the average amount for all IDs and then sum that (ie multiply by) the number of IDs. Try the expression without the TOTAL keyword.
Yes, I know what the aggr function is doing. I need it because of the data structure. The issue is I need to calculate % of totals. So ideally I'd have the formula without TOTAL to get the amount per dimension and then the Formula with TOTAL unless I'm misunderstanding how total works.
This is how it looks:
From what I understand, Aggr would give me this:
I need to calculate % of total to get this:
Num((Avg(Amount)/Sum(TOTAL Aggr(Avg(Amount), ID))),'#,##0%')