topic Re: Firstsortedvalue - expression help in QlikView

Firstsortedvalue - expression help

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I was wondering if someone could help me with a FirstSortedValue() expression. I have create a simple FirstSortedValue() expression :

=FirstSortedValue([TM Event Value], -[TM Event Date])

This returns the Event value of the maximum date and does as it is suppose too. However, I would like to add the condition '[TM Event Name] = 'Metal Wear Reading' to the FirstSortedValue() expression but I am not completely sure how to integrate it - should I use an aggr() or maybe include it in some set analysis.

Any help on this would be greatly apprectaited.

Many thanks,

Brian

Re: Firstsortedvalue - expression help

sunny_talwar — Wed, 07 Dec 2016 17:00:00 GMT

May be this:

=FirstSortedValue({<[TM Event Name] = {'Metal Wear Reading'}>}[TM Event Value], -[TM Event Date])

Re: Firstsortedvalue - expression help

Thu, 08 Dec 2016 08:38:41 GMT

Thanks Sunny that has seem to do the trick!

Much Appreciated - Brian