This content has been marked as final. Show 4 replies
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
but it doesn't work..
Any help will be highly appreciated