Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

CurrencyRates

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.

Screenshot_2.png

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: CurrencyRates

find attached an example

Regards !

View solution in original post

4 Replies
Highlighted
Partner
Partner

Re: CurrencyRates

find attached an example

Regards !

View solution in original post

Highlighted
Partner
Partner

Re: CurrencyRates

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.

Highlighted
Partner
Partner

Re: CurrencyRates

I am sorry but I keep getting Invalid expression error.

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

Highlighted
Partner
Partner

Re: CurrencyRates

Thanks, IT worked like a charm