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 II
Creator II

Re: Text Box - Value link to an expression

Hi nayan,

try with this,

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

Highlighted
Creator
Creator

Re: Text Box - Value link to an expression

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

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

Highlighted
Partner
Partner

Re: Text Box - Value link to an expression

Hi Nayan,

this will work for multiple values:

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

Andy

Highlighted
Creator
Creator

Re: Text Box - Value link to an expression

Thank you Sunny, it worked