SET Flag on Oldest Price in price changes table

[jjordaan]

Hello QlikView addicts,

I have a question. I want to create a flag for the oldest price.

I have the following situation.

Ik have a QlikView table called Item with all item related inotmation.

linked to the item table (field association) I have a tabel with all the price changes per item. An item can have multiple price changes during a certain time.

I want to set a flag (1) on the row of the oldest modification date per item.

What's is the best way to do it.

Does anyone has an example that would help me.

Thanks in advance

[jjordaan]

I do not wanna rush anyone and I appreciate it when someone takes the time to look at someone else's problem, but this issue is very important to me.

So if anyone can help me please.

[jjordaan · Accepted solution]

I resolved the issue with the function lastValue.

[#4]

Can you post the name of function? or approach.

[jjordaan]

The function is called Last Value.

This is how it is described in the help menu.

Returns the last value in load order of expression over a number of records as defined by a group by clause. If no text value is found, NULL is returned. This function is only available as a script function.

Example:

Load City, LastValue(Name), as FirstName from abc.csv group by City;