mininum value

[Anonymous]

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]

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

[Anonymous]

I'm sorry, but I don't understand

Mytable: TICKETS

Myfileds

IDTICKET     TICKETDATE

WHat I've to do ?

[swuehl]

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.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work