topic Re: FirstSortedValue for each name in QlikView

FirstSortedValue for each name

entsh — Thu, 25 Mar 2021 20:49:12 GMT

Please see the below table

I want the last level of each name (largest id)

I want this:

so I use this formula

=firstsortedvalue(level, -id, 1) and its ok !

but i want to use variable! vll=firstsortedvalue(level, -id, 1) and this variable return C for both names and this is wrong answer!

please help me 🙂

Or — Thu, 25 Mar 2021 20:20:00 GMT

Using your formula on your data returned this...

entsh — Thu, 25 Mar 2021 20:36:29 GMT

YES but I used variable ! vLL=firstsortedvalue(level, -id, 1) and use a variable in expressions

it returns C for both names!

how can I use a variable instead of write a formula?

Or — Thu, 25 Mar 2021 20:44:41 GMT

No idea! If you'd asked that in the first place I would have left this for someone else to try and answer... (;

entsh — Thu, 25 Mar 2021 20:47:45 GMT

I appreciate your attention 🙂

Or — Thu, 25 Mar 2021 21:00:39 GMT

I'd give it a whirl with using a string variable and evaluating it within the expression. No idea if that'd work, but that's my best bet.

firstsortedvalue(level, -id, 1)

with no equal sign (so it's a string, not a formula)

Then, =$(vLL) in your expression.

entsh — Thu, 25 Mar 2021 22:11:17 GMT

THX A LOT 🙂