Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Text Box - Value link to an expression

Hi

I need help with an expression in a text box.  Attached herewith is data relating to Calls and the date the Call was created.

I want an expression to tell me which is the oldest call?  The answer should be IR1086.  How do i do this? I have worked out the number of days the oldest call is, which is 197 days.

Please can you assist.

Kind regards

Nayan

1 Solution

Accepted Solutions
Highlighted

Re: Text Box - Value link to an expression

Which of the two would you want to see? If Randomly any... you can try this

=FirstSortedValue(DISTINCT {<[Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call, [Created Date])

If both, then this

=Concat({<[Created Date] = {'$(=Min([Created Date]))'}, [Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call, ', ')

View solution in original post

14 Replies
Highlighted
Master II
Master II

Re: Text Box - Value link to an expression

try this:

date(num(today())-(max(today() - [Created Date])))

hope this helps

Re: Text Box - Value link to an expression

May be use this?

=Only({<[Created Date] = {'$(=Max([Created Date]))'}>}Call)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

Re: Text Box - Value link to an expression

Hi Nayan,

use the following:

=Only({<[Created Date] = {'$(=Min([Created Date]))'}>}Call)

as you are after the OLDEST date

HTH

Andy

Highlighted
Creator II
Creator II

Re: Text Box - Value link to an expression

Hi Nayan,

As Andrew  mention use the following expression given by andrew:

=Only({<[Created Date] = {'$(=Min([Created Date]))'}>}Call)

It works perfectly

Highlighted
Master
Master

Re: Text Box - Value link to an expression

Or by using Firstsortedvalue:

FirstSortedValue(Call,[Created Date],1)

Highlighted

Re: Text Box - Value link to an expression

May be this:

=FirstSortedValue(Call, [Created Date])


Capture.PNG

Highlighted
Creator
Creator

Re: Text Box - Value link to an expression

Hi All

Thank you for your reply.  It was helpful.  I have additional conditions ,where the

  • "Service Level = "Active".
  • Call Type = "Incidents"

See new data attached and the model.

How do I get the oldest Call number?

Kind regards

Nayan

Highlighted

Re: Text Box - Value link to an expression

May be this:

=FirstSortedValue({<[Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call, [Created Date])

Highlighted

Re: Text Box - Value link to an expression

or this:

=Only({<[Created Date] = {'$(=Min([Created Date]))'}, [Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call)