topic Find value from previous date, ignoring weekends and holidays. in QlikView https://community.qlik.com/t5/QlikView/Find-value-from-previous-date-ignoring-weekends-and-holidays/m-p/905200#M314602 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to sum data from the prev open date.</P><P></P><P>I've added a table with holidays, but Im not sure how to implement in qlikView.</P><P>Pls find attached example QV-file</P><P></P><P><STRONG style="color: #ff0000;">Expected result as per below when choosing "2015-Jan". </STRONG></P><P></P><P><SPAN style="color: #000000;">Kind Regards,</SPAN></P><P><SPAN style="color: #000000;">Olle</SPAN><STRONG style="color: #ff0000;"> </STRONG></P><P></P><P><STRONG style="color: #ff0000;"><IMG alt="TodayYesterdaySum.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85062_TodayYesterdaySum.png" style="height: auto;" /></STRONG></P></BODY></HTML> Mon, 27 Apr 2015 08:16:07 GMT 2015-04-27T08:16:07Z Find value from previous date, ignoring weekends and holidays. https://community.qlik.com/t5/QlikView/Find-value-from-previous-date-ignoring-weekends-and-holidays/m-p/905200#M314602 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to sum data from the prev open date.</P><P></P><P>I've added a table with holidays, but Im not sure how to implement in qlikView.</P><P>Pls find attached example QV-file</P><P></P><P><STRONG style="color: #ff0000;">Expected result as per below when choosing "2015-Jan". </STRONG></P><P></P><P><SPAN style="color: #000000;">Kind Regards,</SPAN></P><P><SPAN style="color: #000000;">Olle</SPAN><STRONG style="color: #ff0000;"> </STRONG></P><P></P><P><STRONG style="color: #ff0000;"><IMG alt="TodayYesterdaySum.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/85062_TodayYesterdaySum.png" style="height: auto;" /></STRONG></P></BODY></HTML> Mon, 27 Apr 2015 08:16:07 GMT https://community.qlik.com/t5/QlikView/Find-value-from-previous-date-ignoring-weekends-and-holidays/m-p/905200#M314602 2015-04-27T08:16:07Z Re: Find value from previous date, ignoring weekends and holidays. https://community.qlik.com/t5/QlikView/Find-value-from-previous-date-ignoring-weekends-and-holidays/m-p/905201#M314603 <HTML><HEAD></HEAD><BODY><P>Hi Olle,</P><P></P><P>You can add Field "isHoliday" to your master calendar, and mark holidays there. And then use set analysis in expressions to exclude holidays.</P></BODY></HTML> Mon, 27 Apr 2015 10:19:45 GMT https://community.qlik.com/t5/QlikView/Find-value-from-previous-date-ignoring-weekends-and-holidays/m-p/905201#M314603 yura_ratu 2015-04-27T10:19:45Z