Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

denisetrujillo
New 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
New Contributor III

Re: Currency Conversion

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

2 Replies
Partner
Partner

Re: Currency Conversion

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
New Contributor III

Re: Currency Conversion

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