topic Re: How to use Aggregation at script level in QlikView

How to use Aggregation at script level

Wed, 01 Oct 2014 13:33:26 GMT

Can anybody tell how to use How to use Aggregation at script level

Thanks

Re: How to use Aggregation at script level

anbu1984 — Wed, 01 Oct 2014 13:43:03 GMT

Do you mean using Aggr() ?

Re: How to use Aggregation at script level

Wed, 01 Oct 2014 13:51:25 GMT

Yes Cheliyan,

In Designing we can write avg(aggr(sum(sales),Country)), like this.

similar way i should do the same in the script level

Thanks

Re: How to use Aggregation at script level

anbu1984 — Wed, 01 Oct 2014 14:01:37 GMT

You cannot use Aggr() in script. You can try like this

Initial:

Load * Inline [

Country,Sales,Year

India,1000,2013

India,2000,2014

China,1000,2013

China,200,2014 ];

Join(Initial)

Load Country,Sum(Sales)/Count(Country) As Avg Resident Initial Group by Country;

Re: How to use Aggregation at script level

MarcoWedel — Wed, 01 Oct 2014 21:35:38 GMT

Hi,

there are multiple aggregation functions for the script, they all have in common that there must be a group by clause for all fields loaded but not aggregated:

hope this helps

regards

Marco