topic Re: Is AGGR() like SQL GroupBy? in QlikView

Is AGGR() like SQL GroupBy?

lucasdavis500 — Wed, 25 Nov 2020 16:16:04 GMT

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...

Re: Is AGGR() like SQL GroupBy?

maxgro — Fri, 04 Nov 2016 19:45:54 GMT

You acn find a lot of info on aggr

AGGR...

QlikView Technical Brief - AGGR.docx

and here too (above all the Henric posts)

https://community.qlik.com/search.jspa?q=aggr&type=post

Re: Is AGGR() like SQL GroupBy?

swuehl — Fri, 04 Nov 2016 19:53:37 GMT

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:

Dimensions and Measures