topic Examples on new Aggr syntax in QlikView

Examples on new Aggr syntax

Sun, 18 Dec 2016 14:16:55 GMT

All,

Can any one post some examples on the new Aggr() syntax, especially on the sort able syntax.

vinieme12 — Sun, 18 Dec 2016 17:25:39 GMT

Example scenario where you want to list top 5 countries in Sales in a Text box

Without Sort expression, the countries will be concatenated by load order.

Concat(AGGR(IF(Rank(sum(Sales),1,1)<=5, Country),Country),', ', )

With Sort expression, the countries will be concatenated in Order of RANK 1-5:

Concat(AGGR(IF(Rank(sum(Sales),1,1)<=5, Country),Country),', ', aggr(Rank(sum(Sales),1,1), Country))

maxgro — Sun, 18 Dec 2016 17:31:59 GMT

You can find an interesting examples here

Mon, 19 Dec 2016 06:47:33 GMT

I saw that, but its not that much intuitive in a generic way. Thanks for the reply

gballester — Tue, 21 Nov 2017 13:47:42 GMT

I tried to use it in a simple example and it did not work for me. Do you have a simple example where you can apply?

In my case I used this syntax and it marks me as an error in the editor, when applying calculates but does not order.

=Aggr(SUM(TTRx),(TERRITORY_DESC,(=SUM(TTRx), DESC)))

gballester — Tue, 21 Nov 2017 14:41:09 GMT

a formula used is:

=Aggr(SUM(TTRx),(TERRITORY_DESC,(=SUM(TTRx),(numeric,DESCENDING))))