Hey. I'm pretty new to Qlikview and I have a straight table where I want to highlight the minimum and maximum values in a column. I have been able to successfully highlight one or the other using a background color expression, but I can't seem to figure out how to do both.
You know what, this gave me exactly what I needed. Thanks so much. I didn't wind up using the Aggr() function but I had misused the IF() function before that and your example helped me pin down my syntax.
The_current_Sum is just a repeat of the expression formula.
For All_sums_in_this_column we have to get a series of cell values in the current column. For that we use the aggr() function that will create a Virtuall table with the dimensions listed starting from parameter 2 onwards, and a single expression consisting of parameter 1. When we've obtained this series, we apply the Max function and compare the current cell value to the maximum of the series.
Normally, aggr() will only operate within the limits of the current dimension values. We force aggr() to operate on the whole table by specifying the TOTAL keyword, which is shorthand for set analysis that includes all current dimension values in the current table.
Hope this makes things clearer. But as I said, aggr() is pretty advanced QV technology.