4 Replies Latest reply: Dec 13, 2017 2:23 AM by Angel Tomov RSS


    Angel Tomov

      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