Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
denisetrujillo
Contributor III
Contributor III

Currency Conversion

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.

 

1 Solution

Accepted Solutions
peterbergman
Contributor III
Contributor III

Hi Denise 

This article could maybee be useful

https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-Date-Interval-from-a-Single-Date/ba-p/1467...

 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

Regards

Peter

View solution in original post

2 Replies
marcos_herrera
Partner - Creator III
Partner - Creator III

Hi Denise

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

 

peterbergman
Contributor III
Contributor III

Hi Denise 

This article could maybee be useful

https://community.qlik.com/t5/Qlik-Design-Blog/Creating-a-Date-Interval-from-a-Single-Date/ba-p/1467...

 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

Regards

Peter