Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is the function AGGR() a comparison to SQL Group By statements when using aggregation functions?
I have hardly used this function, but from what I have read of it, it seems that it is equivalent of GROUP BY in SQL, but I have not seen or read any person making that comparison, which leads me to believe it isn't....
They do seem similar... does anyone have an example of how they would be different? Or, is it the case that they are equivalent...
You acn find a lot of info on aggr
QlikView Technical Brief - AGGR.docx
and here too (above all the Henric posts)
You acn find a lot of info on aggr
QlikView Technical Brief - AGGR.docx
and here too (above all the Henric posts)
The aggr() function is creating a virtual table and the dimensions of the aggr() functions can be compared to the fields used in a SQL group by: