Discussion Board for collaboration related to QlikView App Development.
I am generating dates with the below code
Date($(vMinDate)+IterNo()-1) as TempDate
With the field TempDate, I got the dates from 01/01/2018 to 12/31/2019
I have an another field call as Festival, where there are list of holidays are listed
Load * inline [
(This is the sample table with list of holidays)
Now, I have to get a field called as Working days by separating the TempDate and Holidays
I am trying to join the Temp table and Festival table and derive a table as
Date((TempDate-Holidays), 'MM/DD/YYYY') as WorkingDays
But, I dont know why I am getting incorrect WorkingDays
I am not able to understand why the years are generating as 1899 and 1900.
Can any one help me!!!!!
Solved! Go to Solution.
Because when you use "TempDate-Holidays", you will get a number,
the number means the number of days between the TempDate and Holidays.
eg. 2018-01-02 - 2018-01-01 = 1
Actually I'm not really sure what you want, but you can use the "difference" to get what you want.