Discussion Board for collaboration related to QlikView App Development.
Can anybody tell how to use How to use Aggregation at script level
Do you mean using Aggr() ?
In Designing we can write avg(aggr(sum(sales),Country)), like this.
similar way i should do the same in the script level
You cannot use Aggr() in script. You can try like this
Load * Inline [
Load Country,Sum(Sales)/Count(Country) As Avg Resident Initial Group by Country;
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