Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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
Use double quote around the search and single quote around date.
Max(aggr(sum({<Ddate={"<'$(=date(today(1)))'"}>}[num Call ID]),Ddate))
Just noticed. Even this expression should be like that.
max(aggr(sum({<Ddate={"<'$(=date(today(1)))'"}>}dol),Ddate))
You are doing a advanced version of sum([num Call ID]), have you made sure that the [num Call ID] is a numeric value?