How to populate data for missing dates ?

[kaushi2020]

Dear All, I have a scenario where I want to populate same currency and ExchangeRate for the missing dates. 

Date	Currency	ExchangeRate
01-01-2024	USD	5
12-01-2024	USD	6.2
20-01-2024	USD	6.5

In the above table, USD rates have been changed on 12th. i want to fill the table with records with missing dates from 2-Jan till 11 Jan with Currency as USD and ExchangeRate column as 5.

Similarly for 13th till 19th of the dates. 

Thanks in advance.

[hic]

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

This, together with many other tips and tricks, is described in my book "Qlik according to HIC".

HIC

[Or]

Oh, there's a book now?

[hic]

Yup. Check Amazon.

[Or]

Thanks. Must have missed the announcement...