Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vmonitor
Contributor III
Contributor III

I can not get the maximum

Could  you explain to me why?

This expression works fine and I get the result I want.

max(aggr(sum({<Ddate={'<$(=date(today(1)))'}>}dol),Ddate)) 

This expression does not work!

Max(aggr(sum({<Ddate={'<$(=date(today(1)))'}>}[num Call ID]),Ddate))

 
 
4 Replies
Brett_Bleess
Former Employee
Former Employee

Going to be rather difficult for anyone to explain things without the underlying QVW file I believe, as no context for them to try to provide evidence as to what was done wrong...

The best I can offer as help is the following Design Blog post followed by the base URL for this area on Community you can use to search further if you wish.

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Saravanan_Desingh

Use double quote around the search and single quote around date.

Max(aggr(sum({<Ddate={"<'$(=date(today(1)))'"}>}[num Call ID]),Ddate))

 

Saravanan_Desingh

Just noticed. Even this expression should be like that.

max(aggr(sum({<Ddate={"<'$(=date(today(1)))'"}>}dol),Ddate))
Vegar
MVP
MVP

You are doing a advanced version of sum([num Call ID]), have you made sure that the [num Call ID] is a numeric value?