Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Firstsortedvalue - expression help

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

1 Solution

Accepted Solutions

Re: Firstsortedvalue - expression help

May be this:

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

2 Replies

Re: Firstsortedvalue - expression help

May be this:

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

Not applicable

Re: Firstsortedvalue - expression help

Thanks Sunny that has seem to do the trick!

Much Appreciated - Brian