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
As Tresesco suggested,
if(Type='Permenant', Date(Date+45), MakeDate(2020,1,1)) as New_Date
(ooxml, embedded labels, table is Sheet1);