Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

jjordaan
Valued Contributor

SET Flag on Oldest Price in price changes table

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

1 Solution

Accepted Solutions
jjordaan
Valued Contributor

Re: SET Flag on Oldest Price in price changes table

I resolved the issue with the function lastValue.

4 Replies
jjordaan
Valued Contributor

Re: SET Flag on Oldest Price in price changes table

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
Valued Contributor

Re: SET Flag on Oldest Price in price changes table

I resolved the issue with the function lastValue.

Not applicable

Re: SET Flag on Oldest Price in price changes table

Can you post the name of function? or approach.

jjordaan
Valued Contributor

Re: SET Flag on Oldest Price in price changes table

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;

Community Browser