topic Re: FirstSorted Value is Null in QlikView

FirstSorted Value is Null

richard_chilvers — Tue, 31 May 2016 10:58:21 GMT

Sometimes this is a drawback for the FirstSortedValue function: "If more than one value of expression share the same lowest sort-order, the function will return null."

Even where an expression has a single repeated value, it can be useful to have this value returned as the first entry, instead on Null.

Any tips on a neat and easy way of doing this ?

Thanks.

Re: FirstSorted Value is Null

sunny_talwar — Tue, 31 May 2016 11:00:28 GMT

You can use DISTINCT within FirstSortedValue() to show one of them, but to see both you might need to use Aggr() function together with FirstSortedValue.

Re: FirstSorted Value is Null

Kushal_Chawda — Tue, 31 May 2016 11:00:31 GMT

FirstSortedValue(Distinct Dimension, Expression)

Re: FirstSorted Value is Null

Clever_Anjos — Tue, 31 May 2016 11:14:47 GMT

Two solutions

Use Distinct as previous answers
Use a second expression to untie the sorting eg: FirstSortedValue( Dimension, Expression + AnotherExpression/10000)

Re: FirstSorted Value is Null

richard_chilvers — Tue, 31 May 2016 11:14:51 GMT

Thanks.

I wasn't aware that DISTINCT could be used here - I was relying on interactive help which doesn't show it as an option.