Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
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]))

2 Replies
Lisa_P
Employee
Employee

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

everest226
Creator III
Creator III
Author

field is cost