topic Re: How to add days to Existing date Field ? in QlikView

How to add days to Existing date Field ?

madhubabum — Wed, 07 Oct 2015 06:25:09 GMT

Hi Experts

I am having the Employee details ,

Here i want to add 45 days to existing date field like (Create one more field like "Due Date")

Condition should be like as following :

If Benefit Type is ‘Permanent’ then Date + 45 days else 01/01/2020

How we can achieve this one ?

I am attaching sample application and Excel File

Thanks

Madhu

Re: How to add days to Existing date Field ?

tresB — Wed, 07 Oct 2015 06:27:39 GMT

Date(DateField+45) as [Due Date]

In qv timestamp, 1=1 day

1/24 = 1 hour

1/24/60 = 1 minute ...

Re: How to add days to Existing date Field ?

madhubabum — Wed, 07 Oct 2015 06:36:37 GMT

Hi Tresesco

Thanks for your reply

I want to implement the following if condition

If Type is ‘Permanent’ then Date + 45 days else 01/01/2020

Re: How to add days to Existing date Field ?

tresB — Wed, 07 Oct 2015 06:40:24 GMT

Try like:

If( Type='Permanent', Date(Date+45), MakeDate(2020,1,1)) as [Due Date]

Re: How to add days to Existing date Field ?

sujeetsingh — Wed, 07 Oct 2015 06:44:56 GMT

Here is the changed file

Re: How to add days to Existing date Field ?

SreeniJD — Wed, 07 Oct 2015 06:51:09 GMT

As Tresesco suggested,

Try this..

T1:

LOAD Emp_Id,

Emp_Name,

Type,

Date,

if(Type='Permenant', Date(Date+45), MakeDate(2020,1,1)) as New_Date

FROM

[YourPath\Book2 (2).xlsx]

(ooxml, embedded labels, table is Sheet1);

-Sreeni

Re: How to add days to Existing date Field ?

madhubabum — Wed, 07 Oct 2015 10:22:22 GMT

Hi Tresesco

Thanks for Your reply

In my application Days are not adding to my 'Change_Emp_Date' field

here i am attaching sample excel file and application