This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
May be wrongly placed the parenthesis. Perhaps this?
=FirstSortedValue(distinct SF_Job, -Aggr(count(distinct Requisition),SF_Job))
View solution in original post
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]))
I sent you a sample spreadsheet from another post. You can ignore it.
How about this one?
FirstSortedValue(distinct SF_Job, -Aggr(sum([Number of Openings]),SF_Job & ' - '& Max(aggr(Sum([Number of Openings])),[SF_Job]))
Yep. Found it about 20 minutes ago and I haven't had a chance go get back here and post as solved. Thanks.