topic Lookup value on load in QlikView https://community.qlik.com/t5/QlikView/Lookup-value-on-load/m-p/226942#M79097 <HTML><HEAD></HEAD><BODY><P>I have a custom billing calendar that has the following fields: BillingYear, BeginDate, EndDate, and Period and I'm trying to do a lookup into the Billing Calendar when loading my fact data to grab the Billing Year and Period fields based on TransDate. There are no associated fields between Billing Calendar and fact data. So when I load a record, I want to evaluate the TransDate against the BeginDate and EndDate in the Billing Calendar table and get the related Billing Year and Period. Thoughts?</P><P>Thanks - Kevin</P></BODY></HTML> Mon, 19 Jul 2010 16:13:33 GMT 2010-07-19T16:13:33Z Lookup value on load https://community.qlik.com/t5/QlikView/Lookup-value-on-load/m-p/226942#M79097 <HTML><HEAD></HEAD><BODY><P>I have a custom billing calendar that has the following fields: BillingYear, BeginDate, EndDate, and Period and I'm trying to do a lookup into the Billing Calendar when loading my fact data to grab the Billing Year and Period fields based on TransDate. There are no associated fields between Billing Calendar and fact data. So when I load a record, I want to evaluate the TransDate against the BeginDate and EndDate in the Billing Calendar table and get the related Billing Year and Period. Thoughts?</P><P>Thanks - Kevin</P></BODY></HTML> Mon, 19 Jul 2010 16:13:33 GMT https://community.qlik.com/t5/QlikView/Lookup-value-on-load/m-p/226942#M79097 2010-07-19T16:13:33Z Lookup value on load https://community.qlik.com/t5/QlikView/Lookup-value-on-load/m-p/226943#M79098 <HTML><HEAD></HEAD><BODY><P>Take a look at attachment. There are two approach. Comment/Uncomment one approach to see another one.</P></BODY></HTML> Mon, 19 Jul 2010 17:43:25 GMT https://community.qlik.com/t5/QlikView/Lookup-value-on-load/m-p/226943#M79098 2010-07-19T17:43:25Z Lookup value on load https://community.qlik.com/t5/QlikView/Lookup-value-on-load/m-p/226944#M79099 <HTML><HEAD></HEAD><BODY><P>Perfect Nick. thanks for the input.</P><P>Kevin</P></BODY></HTML> Mon, 19 Jul 2010 18:38:49 GMT https://community.qlik.com/t5/QlikView/Lookup-value-on-load/m-p/226944#M79099 2010-07-19T18:38:49Z