Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
find attached an example
Regards !
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.
I am sorry but I keep getting Invalid expression error.
I am working in QlikSense Server, Any thoughts as to why that is?
Thanks, IT worked like a charm