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

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
sunny_talwar

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
Frank_Hartmann
Master II
Master II

try this:

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

hope this helps

Anil_Babu_Samineni

May be use this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
awhitfield
Partner - Champion
Partner - Champion

Hi Nayan,

use the following:

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

as you are after the OLDEST date

HTH

Andy

yoganantha321
Creator II
Creator II

Hi Nayan,

As Andrew  mention use the following expression given by andrew:

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

It works perfectly

stabben23
Partner - Master
Partner - Master

Or by using Firstsortedvalue:

FirstSortedValue(Call,[Created Date],1)

sunny_talwar

May be this:

=FirstSortedValue(Call, [Created Date])


Capture.PNG

Anonymous
Not applicable
Author

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

sunny_talwar

May be this:

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

sunny_talwar

or this:

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