Find value from previous date, ignoring weekends and holidays.

[#1]

Hi,

I need to sum data from the prev open date.

I've added a table with holidays, but Im not sure how to implement in qlikView.

Pls find attached example QV-file

Expected result as per below when choosing "2015-Jan".

Kind Regards,

Olle

[yura_ratu]

Hi Olle,

You can add Field "isHoliday" to your master calendar, and mark holidays there. And then use set analysis in expressions to exclude holidays.