Qlikview Aggr function query

[hiii]

Hi I want to group the columns by net amount using aggr function in the data load editor script not in the charts..

i want to see this filtering in data model

and after filtering the data i need to add column as count for each type how many times it has been repeated

for example u can see the data below file

[hic · Accepted solution]

The Aggr() function is not available in the script, so you need to solve the problem using a "Group By".

Try

Load
Count(Period) as Count,
Sum([Net loss]) as [Net loss],
Area,
path
From <Source>
Group By Area, path ;

[hiii]

thanks it worked