Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

priqvqlik
Contributor

Error Aggr()

I am trying to write below in the datamodel script. and it shows error.

Please help in correcting this.

Aggr(NetWorkDays([Start],Today()),[Start]) as "Networking Days",

1 Reply
MVP
MVP

Re: Error Aggr()

You can't use Aggr() function in the script, it's only available in the front end.

There is not enough information to give you a good advice (in general, you would need a GROUP BY clause and aggregation functions to get something like Aggr() in the script).

But maybe you just need a per record calculation:

NetWorkDays([Start],Today(1)) as "Networking Days",

Community Browser