Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

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
Anil_Babu_Samineni

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

sunny_talwar

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
Anil_Babu_Samineni

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

tmumaw
Specialist II
Specialist II
Author

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

tmumaw
Specialist II
Specialist II
Author

How about this one?

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

Thanks

sunny_talwar

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

tmumaw
Specialist II
Specialist II
Author

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