Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
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
sunny_talwar

May be this

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

antoniotiman
Master III
Master III

Try this

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