topic Re: firstsortedvalue value date descending number ascending in QlikView

firstsortedvalue value date descending number ascending

curiousfellow — Tue, 18 Jun 2019 12:33:24 GMT

I have a table with for example an employeename, dates, and sales_per_customer

Now I want to find for every employee, the highest date and within that date the lowest sales_per_customer.

So I tried firstsortedvalue(employeename, -date, sales_per_customer) but apparently only one sort_weight is allowed ?

So is there another way to achieve this, without having to create a lot of temporary tables 🙂

sunny_talwar — Tue, 18 Jun 2019 12:35:35 GMT

May be this

FirstSortedValue(employeename, -date + (sales_per_customer/1E10))

curiousfellow — Tue, 18 Jun 2019 12:51:15 GMT

I made a simple example, in real life my second field is a string. Perhaps I can do something with the lenght of the string.

Thank you for giving a direction

sunny_talwar — Tue, 18 Jun 2019 13:22:19 GMT

You can do length or rank of string....