CurrencyRates

[tomovangel]

Hello dear Community,

I have been banging my head like crazy with the following problem in QlikSense.

I have a sales table and a currency table.

I need to transfer All amounts into CHF.

From the currency table, I need only the last loaded values for each Currency. 

I can't provide a sample from the database, but I got a test excel file.

So I need to load only 9 rows, 1 row for each Currency .

THIS is the desired output I want in the QlikSense table.

only the latest values for each currency.

-Thanks in advance

i have tried with

LET vCurrency=Peek('zdexr_rate2',-1,'CurrRates'); 

but it doesn't work..

Any help will be highly appreciated

[martinpohl · Accepted solution]

find attached an example

Regards !

[alextimofeyev]

You could also do it in the query when getting data from the database (assuming your real-life data is not in Excel). E.g. in PostgreSQL you could use DISTINCT ON clause.

[tomovangel]

I am sorry but I keep getting Invalid expression error.

I am working in QlikSense Server, Any thoughts as to why that is?

[tomovangel]

Thanks, IT worked like a charm