Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
bibopipo
Contributor II

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
Highlighted
MVP
MVP

Re: mininum value

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

Highlighted
bibopipo
Contributor II

Re: mininum value

I'm sorry, but I don't understand

Mytable: TICKETS

Myfileds

IDTICKET     TICKETDATE

WHat I've to do ?

Highlighted
MVP
MVP

Re: mininum value

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