Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Aggregate issue

sum({<Is = {'N'},IsH = {'N'},[Date]= {">=$(vFrom)<=$(vTo)"},
[order Date]= {">=$(vGFrom)<=$(vGTo)"}> }[Cost])

 

I used Aggregate as below but getting error. i want to use aggr function because the total when exported in excel was not correct . Am i missing something from bellow expression 

 

sum(aggr({<Is = {'N'},IsH = {'N'},[Date]= {">=$(vFrom)<=$(vTo)"},
[order Date]= {">=$(vGFrom)<=$(vGTo)"}> }[Cost]))

Labels (1)
2 Replies
Highlighted
Employee
Employee

Re: Aggregate issue

The aggr() function needs a field to aggregate by, this is missing in your example

Creator III
Creator III

Re: Aggregate issue

field is cost