topic whats wrong with this? in QlikView

whats wrong with this?

Wed, 20 Jul 2011 12:45:36 GMT

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

whats wrong with this?

swuehl — Wed, 20 Jul 2011 12:49:11 GMT

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

whats wrong with this?

swuehl — Wed, 20 Jul 2011 12:53:50 GMT

I think this should work:

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

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

Stefan

whats wrong with this?

Wed, 20 Jul 2011 12:53:59 GMT

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