Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
karan_kn
Creator II
Creator II

Aggr Max date condition in chart Expression

Please help me to fix the below Aggr function in expression, not working correctly

=Aggr(Date(Max(If(update_date <='12/01/2019', update_date)),'MM/DD/YYYY h:mm:ss[.fff] TT'),ID)

1 Reply
Brett_Bleess
Support (Former)
Support (Former)

I would venture the reason you have received no responses is the lack of context, really going to need QVW file with the information provided, as I am not sure how else you expected anyone to know what was wrong with the expression...  Most people are not going to make assumptions etc., so you must include enough information in order for them to be able to research what you are trying to do to sort out why it is not working as you wish.

The best I can do as a point in the right direction is the following Design Blog post and I will include the base URL last in case you wish to search further yourself.

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.