First Value in the table

[surendraj]

Hi All,

in the below table, i need to capture the first value of the price for every model and month_year in a new field. (need in script level)

For Example:

for a model , if we have price for july2017 then we consider that price . if  july2017 has no price then we capture the price for aug2017  and so on ..

[stabben23]

should work, send Excel instead of pic?

[stabben23]

maybe you have to format min(Month_Year) With date?

[surendraj]

not getting in data in latest price field.

[sunny_talwar]

I think stabben23‌ brought up a good point, is your Month_Year understood as date by QlikView?

Why don’t my dates work?

QlikView Date fields

Get the Dates Right

[surendraj]

from data field .. i created month_year field

[stabben23]

looks lika a string(text) value

[surendraj]

after removing the month_year and replacing it with monthlastday field. Below is the data we see .

In the lastestprice field, the value is begin halfed .

[sunny_talwar]

Are you using an expression for Price? or is it direct field reference?

[surendraj]

Price is direct field ...

[surendraj]

No Data in the latestprice