topic Re: Agg & total function difference plz give with exaple . in QlikView

Agg & total function difference plz give with exaple .

Wed, 09 Sep 2015 19:11:57 GMT

hi friends this is babu plz help me this,

Agg & total function difference plz give with exaple .

plz help me friends

Re: Agg & total function difference plz give with exaple .

MK_QSL — Wed, 09 Sep 2015 19:16:34 GMT

From Reference manual

aggr ([ distinct | nodistinct ] [{set_expression}]expression {, dimension})

Returns a set of values of expression calculated over dimensions. The result can be compared to the expression column of a 'local chart', evaluated in the context where the aggr function resides. Each dimension must be a single field. It cannot be an expression (calculated dimension).

If the expression argument is preceded by the nodistinct qualifier, each combination of dimension values may generate more than one return value, depending on underlying data structure. If the expression argument is preceded by the distinct qualifier or if no qualifier is used at all, each combination of dimension values will generate only one return value.

By default, the aggregation function will aggregate over the set of possible records defined by the selection. An alternative set of records can be defined by a Set Analysis expression.

By using this function in Add calculated dimension... it is possible to achieve nested chart aggregation in multiple levels. See also Nested Aggregations and Related Issues.

When used in chart expressions it is possible to achieve Sum of Rows in Pivot Tables.

Examples:

aggr( sum(Sales), Country )

aggr( nodistinct sum(Sales), Country )

aggr( sum(Sales), Country, Region )

count( aggr( sum(Sales), Country ))

TOTAL

What does the TOTAL qualifier do?

Total qualifier

Re: Agg & total function difference plz give with exaple .

tripatirao — Thu, 10 Sep 2015 05:32:16 GMT

The use of Total( ) is it will nullify the selection of any dimension.

And the use of Aggr( ) is it wll works on all rows.

For exemple if the user want to find the top customer doing sales then he can use Aggr() function.

I have attached a sample file .Go through it.

Re: Agg & total function difference plz give with exaple .

kamal_sanguri — Tue, 26 Jan 2016 10:47:52 GMT

Is it possible to create one more column in attached QVW to show % distribution of sales in states for a country..?

For ex: total sales of a Germany is 100% and it is distributed in different states like 35% in Munich, 30 % in Frankfurt and remaining in Berlin..?

Any help would be greatly appreciated.. I am stuck in a similar situation..

Thanks,

-Kamal