topic Group by functionality in QlikView

Group by functionality

Fri, 12 Sep 2014 06:06:49 GMT

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

Re: Group by functionality

tresB — Fri, 12 Sep 2014 06:10:23 GMT

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.

Re: Group by functionality

deepakqlikview_123 — Fri, 12 Sep 2014 06:12:22 GMT

you can use aggr function in this case

Syntax-aggr(expression, dimensions)

thanks

Re: Group by functionality

ychaitanya — Fri, 12 Sep 2014 06:12:46 GMT

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...

Re: Group by functionality

SunilChauhan — Fri, 12 Sep 2014 06:32:55 GMT

aggr(sum(fieldname),fieldforgroupby)

Re: Group by functionality

Fri, 12 Sep 2014 06:50:21 GMT

Thanks to all for your valuable responses, working on it.