Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Partner
Partner

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

 

Highlighted
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