Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY

Re: Select a Cost at a point of time

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)