Currency conversion using the peek () function

[ravvibabji]

Random Date & their conversion rates will be there, you need to map every order date with respect to its interval dates of conversion in data. (Eg. 01/01/2008 INR Rate - 75, 14/01/2008 INR Rate 77.5, orderdate 07/01/2008 - It should pickup 01/01/2008 Conversion rate & Order date with =>14/01/2008 should pickup conversion rate of 14/01/2008

[Bhushan_Mahajan]

@ravvibabji Use below blog.

https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/ba-p/1470637