topic Re: FirstSortedValue in QlikView

FirstSortedValue

Karim_Khan — Tue, 03 Nov 2015 11:14:44 GMT

Hi Team,

I was making the scenario for FirstSortedValue() function.I am littele bit confused about '-' symbol.It will give the max value or min value.

Regards,

Re: FirstSortedValue

sunny_talwar — Tue, 03 Nov 2015 11:18:14 GMT

If you use it in a chart like the way you have used it, you will see all the values. It will essentially work the same way as Only() function. But if you use this in text box object, you will see difference. -Salary will show the Name associated with the person having the maximum salary, where as Salary will show the Name associated with the person with lowest salary

Re: FirstSortedValue

miguelbraga — Tue, 03 Nov 2015 11:19:12 GMT

Hi Karim,

The symbol '-' gives you the max value. Just delete that symbol, and you'll get the min value

Regards,

Re: FirstSortedValue

MK_QSL — Tue, 03 Nov 2015 11:22:51 GMT

Use

firstsortedvalue(Distinct Name,-Salary)

Re: FirstSortedValue

Karim_Khan — Tue, 03 Nov 2015 11:25:28 GMT

Thanks for always helping