tfacs calendar and holidays

[#1]

Hello!

I have converted the SAP TFACS table calendar into a readable calendar in QlikView. I followed the example from this discussions:

https://community.qlik.com/thread/56242

However I still have holidays and working days information stored in a separate column as 0 and 1 values and I would like to add them to a calendar so I could see the holidays for each relevant calendar(per country as per calendar ID) and compare to other dates from other fields.

My current table looks like this:

  Could anyone, please, give any hints on this?

I also would like to calculate the last, the second last and the third last working day of the month after adding the holidays in it.