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: 
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
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

691 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 🙂
519 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

519 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?

519 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

519 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

519 Views