Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

mininum value

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

3 Replies
swuehl
MVP
MVP

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

Anonymous
Not applicable
Author

I'm sorry, but I don't understand

Mytable: TICKETS

Myfileds

IDTICKET     TICKETDATE

WHat I've to do ?

swuehl
MVP
MVP

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