Script Creation

[#1]

Hey I have a file that has conversion ratios up to a certain date. But I am joining these on to another table with just a date range that matches the invoice dates.

I would like to have all the dates past my conversion ratio to be the last conversion made rather than null. I've attached a test example.

Thanks,

Kevin

[#2]

Hey Kevin,

I would do something like this. I created a dummy table with data similar to what you explained. So for dates that don't have a conversion factor the last available date's conversion factor should be copied over to the rest of the dates(If i understood correctly).

Hope it helps

Thanks

AJ

[Anonymous · Accepted solution]

If( IsNull( Ratio ), Peek( Ratio ), Ratio ) as Ratio

Generating Missing Data In QlikView

[#4]

This is what I ended up figuring outl. Thanks!!