Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-12-04 11:11 AM

What is the use of FirstSortValue in QlikView?

Hi All,

What is the use of FirstSortValue in QlikView?

Thanks in Advance.

631 Views
0 Likes
2 Replies
sunny_talwar
MVP
MVP
‎2015-12-04 12:36 PM

See if this link helps: Value Associated with Min/Max Value of Another Field (Front End Solution)

448 Views
0 Likes
Clever_Anjos
Employee
Employee
‎2015-12-04 02:10 PM

Basically when you want to calculate a rank based on an aggregation on another field

FirstSortedValue( Customer, aggr(-sum(sales),Customer))) will bring you the Customer with highest sales

448 Views
0 Likes