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

adding number of days to date to get a date

I am trying to add date + no of days to get a date.

Whats wrong in below code?

Lookup('LEAD TIME_D','DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE',[DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE],'DIE_LEADTIME') as DIE_LEAD_TIME,

Date(DIE_DUE_DT + Lookup('LEAD TIME_D','DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE',[DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE],'DIE_LEADTIME')) as LEAD_DIE_DUE_DT

Tags (1)
2 Replies

Re: adding number of days to date to get a date

please post sample data/app

Gabriel
Valued Contributor II

Re: adding number of days to date to get a date

Hi riadesai,

I agree with Marco, please post a sample data.

What I was also thinking of is, use preceding LOAD

Table1:

LOAD

Date(DIE_DUE_DT + Lookup('LEAD TIME_D','DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE',[DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE],'DIE_LEADTIME')

;

Lookup('LEAD TIME_D','DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE',[DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE],'DIE_LEADTIME') as DIE_LEAD_TIME

FROM $(vRelativePath);

However it will be lovely if you can post sample data.

Community Browser