topic Aggregated sum by max date in QlikView

Aggregated sum by max date

Anonymous — Wed, 17 Feb 2016 13:00:17 GMT

Good day!

I have some source:

I expression i need to calculate Sales by Id. if some Id has more then one Date, expression must get max date.

Thanks.

Gysbert_Wassenaar — Wed, 17 Feb 2016 13:17:55 GMT

Try FirstSortedValue(Sales, -Date)

sunny_talwar — Wed, 17 Feb 2016 13:27:51 GMT

Implementation of Gysbert's suggestion:

Anonymous — Wed, 17 Feb 2016 13:41:29 GMT

Thanks!

Anonymous — Wed, 17 Feb 2016 13:42:23 GMT

Thank you!

Can i use filters inside this expr?

sunny_talwar — Wed, 17 Feb 2016 13:43:16 GMT

You sure can

jolivares — Wed, 17 Feb 2016 13:47:48 GMT

The expression is:

FirstSortedValue(Sales, -Aggr(Max(Date(Date#(Date,'DD.MM.YYYY'))),Id,Date ))

But you have to take care of your field "Date", is better if you put in the correct format.

sunny_talwar — Wed, 17 Feb 2016 13:48:46 GMT

You can add set analysis to FirstSortedValue function:

FirstSortedValue({<Field = {'Something'}>} Sales, -Date)