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

    CurrencyRates

    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.

      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