Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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

14 Replies
yoganantha321
Creator II
Creator II

Hi nayan,

try with this,

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

Anonymous
Not applicable
Author

Thank you all for the responses to my second question.

One quick question.  If there are 2 Calls that have the same oldest date, the Call numbers wont show.  Is that correct or is there a way to solve this?

Kind regards

Nayan

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, ', ')

awhitfield
Partner - Champion
Partner - Champion

Hi Nayan,

this will work for multiple values:

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

Andy

Anonymous
Not applicable
Author

Thank you Sunny, it worked