Re: First Sorted Values - Qlik Community

qlikview979 · ‎2016-07-21

Hi Experts,

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

Regards

Mahesh

PrashantSangle · ‎2016-07-21

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 · ‎2016-07-21

Hi Bro,

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

Regards

tresesco · ‎2016-07-21

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 · ‎2016-07-21

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 · ‎2016-07-21

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