mininum value - Qlik Community

Anonymous · ‎2014-02-06

Dear all,

I've a ticket table with IDTICKET and TICKETDATE fields.

I need to show into a text box, the oldest ticket ID and its date.

How can I solve it ?

Help please

Thanks in advance

swuehl · ‎2014-02-06

='ID: ' & FirstSortedValue(IDTICKET,TICKETDATE) & ' at ' & date(min(TICKETDATE))

Anonymous · ‎2014-02-06

I'm sorry, but I don't understand

Mytable: TICKETS

Myfileds

IDTICKET TICKETDATE

WHat I've to do ?

swuehl · ‎2014-02-06

bibopipo wrote:

I need to show into a text box, the oldest ticket ID and its date.

Create a text box, input:

='ID: ' & FirstSortedValue(IDTICKET,TICKETDATE) & ' at ' & date(min(TICKETDATE))

To make this work, TICKETDATE must have a numeric representation like all QV date and time values should have.