Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

qlikview979
Valued Contributor

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

Re: First Sorted Values

Hi,

best explanation in help menu.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
qlikview979
Valued Contributor

Re: First Sorted Values

Hi Bro,

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


Regards

MVP
MVP

Re: First Sorted Values

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
Honored Contributor

Re: First Sorted Values

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
Honored Contributor

Re: First Sorted Values

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