topic Re: First Sorted Value returning NULL in QlikView

First Sorted Value returning NULL

Thu, 14 Apr 2016 18:58:55 GMT

Hello.

With the user's help Sunny, function firstsortedvalue takes the highest value of the highest date that occurs on a table, but many times the value of the expression returns null, the model presented in the previous question I had only integer values, but I own decimals values, there is a problem in function to decimal values?

Formula:

FirstSortedValue (Value - (Date * 10000 + Value))

Re: First Sorted Value returning NULL

sunny_talwar — Thu, 14 Apr 2016 19:01:43 GMT

May be use DISTINCT?

FirstSortedValue(DISTINCT Value - (Date * 10000 + Value))

If that doesn't work, would you be able to share how your data look like (where it doesn't work)

Re: First Sorted Value returning NULL

sunny_talwar — Thu, 14 Apr 2016 19:02:57 GMT

One reason this isn't working could be the fact the Date is not read as Date. Make sure Date is a dual field with numeric value. Check these links:

Dates in Set Analysis

Why don’t my dates work?

Re: First Sorted Value returning NULL

Thu, 14 Apr 2016 19:10:24 GMT

Works!

But what's the difference using distinct in this function?

Re: First Sorted Value returning NULL

sunny_talwar — Thu, 14 Apr 2016 19:14:06 GMT

As this has decimal values, it might be finding difficult to choose between two very close values

For example: 10.99999999999 and 10.99999999998. Distinct just help the expression choose one of them randomly.