topic Re: question on expression with two or more rows in QlikView

question on expression with two or more rows

Anonymous — Thu, 06 Nov 2014 00:25:52 GMT

Is there a way to create an expression to only return value based on the latest Date?

For example, there are two entries for the same item but I want to return $100,000 as it has the latest date changed.

thanks!

Derrell

Re: question on expression with two or more rows

danieloberbilli — Thu, 06 Nov 2014 00:31:38 GMT

try something like this in your P8_EstimatedValue expression: I use 'sum' - maybe in your case you rather use only(), avg() or whatever suits your calculation:

=sum({<LastChangedDate={"=max(LastChangedDate)"}>} P8_EstimatedValue)

edited: sorry - I meant to write LastChangedDate...not CreatedDate

Re: question on expression with two or more rows

Anonymous — Thu, 06 Nov 2014 01:48:02 GMT

Thanks Daniel.

I was still getting the sum of both the values. Further searching I found a solution as below:

Sum(If(Aggr(NODISTINCT Max(LastChangedDate), P8_OpportunityID) = LastChangedDate, P8_EstimatedValue))