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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

Aggr syntax check

Can someone spot where im going wrong?

aggr(avg(count({$< MainCarriagewayDataFilteringOutput.site1.v = {'<50'}>} Timestamp)),weekday(Date))

what its supposed to do is produce the average number of minutes (theres one record a min) for each day.

10 Replies
sunny_talwar

The 'dimensions' in an Aggr() cannot be calculated dimensions, only field names are allowed here.

Learned something new today . Thank you jonathan