Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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: 
qlikview979
Specialist
Specialist
‎2016-07-21 07:36 AM

First Sorted Values

Hi Experts,

How to use first sorted value in Script level ? Can any one Explain  me with Example?

Regards

Mahesh

854 Views
0 Likes
5 Replies
PrashantSangle
MVP
MVP
‎2016-07-21 07:38 AM

Hi,

best explanation in help menu.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
682 Views
0 Likes
qlikview979
Specialist
Specialist
‎2016-07-21 07:42 AM
Author

In response to PrashantSangle

Hi Bro,

I am getting correct output from front end,  not getting form script .


Regards

682 Views
0 Likes
tresesco
MVP
MVP
‎2016-07-21 07:45 AM

In response to qlikview979

One quick check: FirstSortedValue() is an aggregation function. You have to use it with Group By clause in the script. Are you doing so?

682 Views
0 Likes
beck_bakytbek
Master
Master
‎2016-07-21 07:46 AM

Hi Makesh,

This Function you can use to obtain the top value in a sorted list of values, and this function can be used both: in the script and in Charts.

beck

682 Views
0 Likes
beck_bakytbek
Master
Master
‎2016-07-21 08:03 AM

hi Mahesh,

on the base of this link / Video: you can see, how to use this function

QlikView | Expressions | AGGR Function with Max and FirstSortedValue function - YouTube

beck

682 Views