topic Re: FirstSortedValue Expression in QlikView

FirstSortedValue Expression

tmumaw — Sat, 16 Nov 2024 02:53:50 GMT

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

Anil_Babu_Samineni — Fri, 26 Jul 2019 15:36:08 GMT

May be wrongly placed the parenthesis. Perhaps this?

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

tmumaw — Fri, 26 Jul 2019 15:53:06 GMT

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

tmumaw — Fri, 26 Jul 2019 16:05:19 GMT

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 — Fri, 26 Jul 2019 18:03:43 GMT

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]))

tmumaw — Fri, 26 Jul 2019 18:32:29 GMT

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