topic Concat max dates of currently selected field value in QlikView

Concat max dates of currently selected field value

Mon, 21 Jan 2013 11:18:25 GMT

Hello,

My table is:

My goal is to show max date of currently selected Warehouses (WH)!

For selected WH3 and WH2 I want to see: Last record for WH3 - 06.01.2013, WH2 - 03.01.2013

For concat dates I've played with this(does not work):

Concat(Aggr(Date(RangeMax({1<WH={"$(=WH)"}>} Date1)),WH),',')

swuehl — Mon, 21 Jan 2013 11:34:44 GMT

Try

=concat( aggr(WH & ' - ' & Date(max(Date1)),WH),', ')

Mon, 21 Jan 2013 11:49:34 GMT

Thank you!