Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qvqfqlik
Creator
Creator

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
swuehl
MVP
MVP

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",