Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
Digital Support
Digital Support

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.
Highlighted
Specialist III
Specialist III

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

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

 

Highlighted
Specialist III
Specialist III

Just noticed. Even this expression should be like that.

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

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes