Re: How to get functions like Stdev, Sum, Avg, etc. into rows in a table?
Generally you will only see effects with AGGR that will help you understand how to use it when you have more than 1 dimension, otherwise you are only aggregating over the dimension you have.
You may or may not find the below helpful. Personally so I don't get drawn in to the data I quite like to set up toy examples with very simple data that I can point to/print out/scribble on. This one I did when I was trying to 'revise' AGGR for the QlikView BA exam I did a while ago (I'd used it in work, but quite a while before and for me it is easy to get rusty on AGGR).
So in the below the function min(aggr(sum(Mea1), Dim2)) means the minimum value of sum(Mea1) aggregated over Dim2, but for the Dim1 of each row (as there is no TOTAL in there).
So for Dim1=A, you can have Dim2=A or B, so you get 2 values; Dim1=A & Dim2=A top 2 rows (table bottom left) - so sum is 2 Dim1=A & Dim2=B fourth row - so sum is 2 (again) Hence min=2
For Dim1=B, you can have Dim2=C or D, so again 2 values; Dim1=B & Dim2=C third row - so sum is 2 Dim1=B & Dim2=D fifth row - so sum is 4 Hence min=2
I passed the exam, so I assume at least it was right in my head at the time 😀.