Discussion Board for collaboration related to QlikView App Development.
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
Date(DateField+45) as [Due Date]
In qv timestamp, 1=1 day
1/24 = 1 hour
1/24/60 = 1 minute ...
Thanks for your reply
I want to implement the following if condition
If Type is ‘Permanent’ then Date + 45 days else 01/01/2020
If( Type='Permanent', Date(Date+45), MakeDate(2020,1,1)) as [Due Date]
Here is the changed file
As Tresesco suggested,
if(Type='Permenant', Date(Date+45), MakeDate(2020,1,1)) as New_Date
(ooxml, embedded labels, table is Sheet1);
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