topic Data from latest date, from 2 tables in QlikView

Data from latest date, from 2 tables

Tue, 14 Dec 2010 10:20:05 GMT

Hi,

I have 2 tables (rates and rates_date). Rates includes historical rates for a price and rates_date includes the date connected for each rates.

What I want to pick out now is the rates with the latest rates_date, I hope someone can help me with this.

Tue, 14 Dec 2010 10:27:12 GMT

Hi,

Sort it in reversed order.

Also, you can have list box of Dates in descending order.

Just click on latest date and you will get respective Rate.

Happy Thoughts

Tue, 14 Dec 2010 10:27:25 GMT

Hi Fredrik,

please provide a short data extract we can work with.

Thank´s.

Rainer

Tue, 14 Dec 2010 10:42:54 GMT

Hi,

Sorry, forgot to say that I want the result in a new column in an new table. Like this:

1) Find the latest rates_date

2) Pick out the rates that is connected to the rates_date and import that to the column "Rate" (in the new table)

Is there any function that I can use that can do this?