Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

First Sorted Values

Hi Experts,

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

Regards

Mahesh

5 Replies
PrashantSangle

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 🙂
qlikview979
Specialist
Specialist
Author

Hi Bro,

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


Regards

tresesco
MVP
MVP

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

beck_bakytbek
Master
Master

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

beck_bakytbek
Master
Master

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