Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

FirstSortedValue Expression

Does anyone see anything wrong with this expression?

=FirstSortedValue(distinct(SF_Job, - Aggr(count(distinct(Requisition),SF_Job))

I'm trying to use it in a text box.

Thanks

Labels (1)
2 Solutions

Accepted Solutions
Highlighted

May be wrongly placed the parenthesis. Perhaps this?

=FirstSortedValue(distinct SF_Job, -Aggr(count(distinct Requisition),SF_Job))

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)

View solution in original post

Highlighted

Try this... again issues related to the placement of parenthesis

FirstSortedValue(DISTINCT SF_Job, -Aggr(Sum([Number of Openings]), SF_Job))
& ' - '&
Max(Aggr(Sum([Number of Openings]), [SF_Job]))

 

View solution in original post

5 Replies
Highlighted

May be wrongly placed the parenthesis. Perhaps this?

=FirstSortedValue(distinct SF_Job, -Aggr(count(distinct Requisition),SF_Job))

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)

View solution in original post

Specialist
Specialist

I sent you a sample spreadsheet from another post.  You can ignore it. 

Highlighted
Specialist
Specialist

How about this one?

FirstSortedValue(distinct SF_Job, -Aggr(sum([Number of Openings]),SF_Job & ' - '& Max(aggr(Sum([Number of Openings])),[SF_Job]))

Thanks

Highlighted

Try this... again issues related to the placement of parenthesis

FirstSortedValue(DISTINCT SF_Job, -Aggr(Sum([Number of Openings]), SF_Job))
& ' - '&
Max(Aggr(Sum([Number of Openings]), [SF_Job]))

 

View solution in original post

Highlighted
Specialist
Specialist

Yep.  Found it about 20 minutes ago and I haven't had a chance go get back here and post as solved.  Thanks.