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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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