QlikView documentation and resources.
AGGR is a very powerful aggregation function that is sometimes overlooked in the user interface due to is not being properly understood or indeed a developer not being sure how it can be utilised. Often, a QlikView developer will revert to more complex scripting or pre-aggregating data to service an expression that is required in a chart, which can actually be solved by using AGGR.
Hi,
how would the expression look like, when I want to display Fred and the Top 3 others of the list ?
So basically a set returned by the ranking function + a static value
=concat(distinct IF(aggr(rank(sum({<Salesperson-={'Fred'}>}Sales)),Salesperson)<=3,Salesperson[add Fred here to the set of Salespersons]),CHR(13),-aggr(sum(Sales),Salesperson))
Very good document. Thanks for sharing.
If your having trouble using AGGR this might be the document for you. It's well explained and the author makes it easy to understand. Also, several simple yet useful example are provided to show some uses of AGGR.
Bit confused by in using the rank function along with the Aggr. In some example I have seen Rank used outside the Aggr. In this document, rank function is used inside the Aggr.
Just curious, isn't Rank compares things and ranked the items, so ins't outside Aggr, so the virtual table produced by the Aggr can br ranked.
Also it is assumed that internal table produced would be sorted from highest to lowest, just wonder if we need the reverse, how to do that.
Thanks.@aby
Thank you for sharing.
This helped me understand aggr, thanks!
Hi Adam,
Great function, i learned that aggr on a sorted table (in the rijgt way) increase the speed. But i do not realy understand why this is. Can you tel me when to use order by and when not ?
thanks in advance
Lidia
Hi need help
FirstSortedValue(Product,aggr(sum(Sales),Product)) is not returning any name though FirstSortedValue(Product,-aggr(sum(Sales),Product)) is giving me the minimum sales product