Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a table of daily USD:[OTHER-CCY] FX rates. e.g. I have USD:ARS, USD:BRL, USD:HUF.
What I want to do is to create a cross table for each of the other currencies per day.
e.g. I need daily to make [ccy1]:[ccy2] - ARS:BRL, ARS:HUF, BRL:ARS, BRL:HUF, HUF:ARS, HUF:BRL
This is done by: taking 1/ccy1(rate) * ccy2(rate)
I want to make 1 table containing all the cross rates for each day, but I want to do it in the data load editor.
Example below:
I know the logic of how to do it, but I don't know how to implement it in Qlik at all.
Thank you for taking the time to read this. I look forward to reading your replies.
Hi Fred,
The Interval Match function does magic for what you need to achieve. Check it out here:
https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...
I hope that helps!
Kind regards,
S.T.
Hi Stoyan, I'm not sure if I don't understand the interval match function. But from looking into it this doesn't seem to be what I am looking for at all.
Best I have is the following Design Blog post, hopefully it may be what you were looking for to help you out:
https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083
Regards,
Brett