Select a Cost at a point of time

[gkouris77]

Hi, i am new to Qlik Sense and I am trying to select a cost in point of time, and i cant seem to get the correct expression.

So i have a list Average Cost, and what i need is based on the Selected date i want to return the max date average cost that is equal to or less to the selected date. I have tried the below, expression but i cannot get it to work.

=if($(vSelectDate)=<[TransDate],max([TransDate],[TransDate]=<$(vSelectDate)),[TransDate])

Any help would be appreciated.

Thanks

George

[Anil_Babu_Samineni]

This is my last attempt from me?

Script looks like?

LOAD Date(TransDate,'DD-MM-YYYY') as TransDate,

Peek(TransDate) as Previous,

     AverageCost

FROM

(ooxml, embedded labels, table is Sheet1);

And Measure either of the below?

FirstSortedValue(AverageCost, -Aggr(Sum({<TransDate = P(Previous)>} AverageCost), Previous))

Or

Sum({<TransDate = P(Previous)>} AverageCost)