Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qv,
Can we perform group by functionality at chart level.
In attached image, I have a straight table.
My requirement is to arrange them group by account. Is it possible to do.
Thanks,
Ananth
Aggr() is equivalent of script Group By. However, you can use Total as well based on your requirement in a chart, learn them, else explain your requirement with sample data to be helped in a detailed manner.
you can use aggr function in this case
Syntax-aggr(expression, dimensions)
thanks
Aggr() wil be handy for such type of requirement
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.
You will see in the examples later in this document that AGGR can be used in both Expressions and Dimensions.
If we were to provide a short description of AGGR it would be -
When it is used, the AGGR statement produces a virtual table, with one expression and grouped by one or more dimensions. The contents / result of this virtual table can then be used / aggregated by a further outer aggregation function(s).
Hope this helps...
aggr(sum(fieldname),fieldforgroupby)
Thanks to all for your valuable responses, working on it.