Discussion board where members can get started with Qlik Sense.
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
find attached an example
View solution in original post
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