topic Re: Qlikview Aggr function query in QlikView

Qlikview Aggr function query

hiii — Wed, 13 Jul 2022 07:16:08 GMT

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 — Wed, 13 Jul 2022 07:28:09 GMT

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 — Wed, 13 Jul 2022 07:40:50 GMT

thanks it worked