topic Re: Usage of FirstSortedValue() in QlikView

Usage of FirstSortedValue()

Ibobob70 — Thu, 09 Jun 2022 06:59:29 GMT

Hi all

I'm trying to use the function FirstSortedValue() to find the first value according to three columns. The ID column, the Date column and the the Name column. Could somebody helps me? thanks in advance for your help :). see the dataset .

Re: Usage of FirstSortedValue()

BrunPierre — Thu, 14 Jul 2022 18:22:17 GMT

@Ibobob70 Could you share the desired output?

Re: Usage of FirstSortedValue()

Or — Thu, 14 Jul 2022 19:03:18 GMT

Since FirstSortedValue takes a single sort_weight parameter, I believe you'd need to turn those three fields into one somehow:

1) In script by loading them in sorted order and adding a row number or autonumber field for sorting later

2) By concatenating them as a string (note - this will result in string based sorting rather than numeric)

3) By converting the Name column into a numeric value and adding the values up, e.g.

(ID * 10000000) + (Date*100) + ord(Name) // Note - this assumes Name is a single letter

Re: Usage of FirstSortedValue()

Ibobob70 — Tue, 04 Oct 2022 11:03:33 GMT

Thank you for your help 🙂 i'll try it.