Get Qlikview Tips delivered to your in box
In this lesson, we will explore an obscured yet powerful aggregation function in Qlikview.
Email Address:
I really Like the way you explained Use of AGGR() , hats off, Thank You.
[…] AGGR function can be used along with RANK function to show top N values in a pivot table. You will also learn how to use RangeSum function to calculate a rolling total in a multi-dimensional table. […]
[…] dimension. If you are not familiar with these functions then please review my articles on AGGR function in QlikView and how to use Rank […]
[…] of my favorite topics such as AGGR function, Set Analysis and Alternate States have been explained well. This comes as no surprise considering […]
← Older Posts | Newer Posts →
Ketan 4:09 am on April 1, 2013 Permalink
I really Like the way you explained Use of AGGR() , hats off, Thank You.
Qlikview for Developers Cookbook « Learn Qlikview 1:11 pm on July 2, 2013 Permalink
[…] AGGR function can be used along with RANK function to show top N values in a pivot table. You will also learn how to use RangeSum function to calculate a rolling total in a multi-dimensional table. […]
A QlikView Tip: How to display top N and bottom N values « Learn Qlikview 2:21 am on November 1, 2014 Permalink
[…] dimension. If you are not familiar with these functions then please review my articles on AGGR function in QlikView and how to use Rank […]
QlikView Your Business: A Book Review « Learn Qlikview 12:32 am on October 28, 2015 Permalink
[…] of my favorite topics such as AGGR function, Set Analysis and Alternate States have been explained well. This comes as no surprise considering […]