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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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
Champion III
Champion III

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