topic Re: I can not get the maximum in QlikView

I can not get the maximum

vmonitor — Fri, 21 Feb 2020 08:01:07 GMT

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))

Re: I can not get the maximum

Brett_Bleess — Wed, 25 Mar 2020 20:13:53 GMT

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

Re: I can not get the maximum

Saravanan_Desingh — Sun, 07 Jun 2020 22:00:06 GMT

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

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

Re: I can not get the maximum

Saravanan_Desingh — Sun, 07 Jun 2020 22:01:22 GMT

Just noticed. Even this expression should be like that.

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

Re: I can not get the maximum

Vegar — Sun, 07 Jun 2020 22:13:34 GMT

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