Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Concat max dates of currently selected field value

Hello,

My table is:

WHDate1
WH101.01.2013
WH102.01.2013
WH203.01.2013
WH304.01.2013
WH305.01.2013
WH306.01.2013
WH407.01.2013

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),',')

1 Solution

Accepted Solutions
MVP
MVP

Re: Concat max dates of currently selected field value

Try

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

2 Replies
MVP
MVP

Re: Concat max dates of currently selected field value

Try

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

Not applicable

Re: Concat max dates of currently selected field value

Thank you!

Community Browser