Solved: Concat max dates of currently selected field value - Qlik Community

Report Inappropriate Content · ‎2013-01-21

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 · ‎2013-01-21

Try

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

swuehl · ‎2013-01-21

Try

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

Report Inappropriate Content · ‎2013-01-21

Thank you!