Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-02-06 05:55 PM

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

Labels (1)
Labels
793 Views
0 Likes
3 Replies
swuehl
Champion III
Champion III
‎2014-02-06 05:57 PM

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

722 Views
0 Likes
Anonymous
Not applicable
‎2014-02-06 06:19 PM
Author

In response to swuehl

I'm sorry, but I don't understand

Mytable: TICKETS

Myfileds

IDTICKET     TICKETDATE

WHat I've to do ?

722 Views
0 Likes
swuehl
Champion III
Champion III
‎2014-02-06 06:23 PM

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

722 Views
0 Likes