Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

whats wrong with this?

Hello Experts,

Whats wrong with the below expression here???

I am trying to get the maximum of the date_value when i select year dimension and then show the sales... year and month are generated from date_value field which is in dd/mm/yyyy 00:00:00 format..

=sum({$<year = {'$(=max(date_value))'}>}reportValue)

Thanks,

Mady

3 Replies
swuehl
MVP
MVP

Hi Mady,

please note that your current selection is still valid, because aof the first $ in your set expression.

If you select one date, you only get the value of that date.

Try, 1 instead of $ for full year sum.

Stefan

swuehl
MVP
MVP

I think this should work:

=sum({1<year = {$(=year(max(date_Value)))}>}reportValue)

(removed the '' and added year() function)

Stefan

Not applicable
Author

No use Stefan, please check the other discussion I have updated...