Discussion board where members can get started with Qlik Sense.
CAN YOU HELP ME PLEASE!!
I need to convert the sales to the corresponding exchange rate.
I have the table of exchange rate and the table of sales.
my question is if the date and the exchange rate are not registered, that assigned the last registration or the previous registration.
Go to Solution.
This article could maybee be useful
And after you have a table with the intervals you can either use a while loop to make records for all the missing dates or you can use the intervalmatch function
If you want register the prevous or last exchange date when the date are not registered, my suggestion is complete the exchange table, i can send an script example to achieve the request