Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Script Creation

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

1 Solution

Accepted Solutions
michael_gardner
Contributor III

Re: Script Creation

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

Generating Missing Data In QlikView

3 Replies
Not applicable

Re: Script Creation

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

michael_gardner
Contributor III

Re: Script Creation

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

Generating Missing Data In QlikView

Not applicable

Re: Script Creation

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

Community Browser