topic Re: mininum value in QlikView

mininum value

Anonymous — Thu, 06 Feb 2014 22:55:21 GMT

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 — Thu, 06 Feb 2014 22:57:53 GMT

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

Anonymous — Thu, 06 Feb 2014 23:19:41 GMT

I'm sorry, but I don't understand

Mytable: TICKETS

Myfileds

IDTICKET TICKETDATE

WHat I've to do ?

swuehl — Thu, 06 Feb 2014 23:23:54 GMT

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.