Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Dates in text object

Hi ,

I have few dates as belwo

ID     Date Type          Date

1       Renewal           11/10/2018

1       Cancellation     10/10/2020

1       Cancellation     10/10/2018

In Text object I want to show most recent date (min(Date)) on each date type.

Renewal - 11/10/2018 &'-'& Cancellation - 10/10/2018

Can this be done ?

Than you very much

2 Replies
Highlighted

Re: Dates in text object

May be this

'Renewal - & Min({<[Data Type] = {'Renewal'}>} Date) & ' -  Cancellation - ' & Min({<[Data Type] = {'Cancellation'}>} Date)

Highlighted
Master III
Master III

Re: Dates in text object

Try this

=Concat(DISTINCT [Date Type]&'-'& Aggr(NODISTINCT MinString(Date),[Date Type]),Chr(10))