https://community.qlik.com/t5/QlikView/Need-help/m-p/1859631#M1216081 <P>It depends on what your data is structured like, but let's assume you have a calendar table, with a field called Date and field called IsHoliday (1 indicates that date is a holiday).</P> <P>=sum({&lt; Date={"$(=date(today()-2))"}, IsHoliday={1} &gt;} 1)&nbsp;</P> <P>if that's &gt; 0, today - 2 = holiday.</P> Mon, 15 Nov 2021 23:04:34 GMT stevejoyce 2021-11-15T23:04:34Z https://community.qlik.com/t5/QlikView/Need-help/m-p/1859531#M1216080 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4" data-click-id="text"> <DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root"> <P class="_1qeIAgB0cPwnLhDF9XSiJM">I am new to qlikview and Need help. I want to Check if for Example today -2 days was a Holiday (all written down in table Holiday) and then just give a Feedback. I cant even Write the if.. Thanks for the help!</P> </DIV> </DIV> Mon, 15 Nov 2021 18:21:43 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/1859531#M1216080 liziegarb 2021-11-15T18:21:43Z https://community.qlik.com/t5/QlikView/Need-help/m-p/1859631#M1216081 <P>It depends on what your data is structured like, but let's assume you have a calendar table, with a field called Date and field called IsHoliday (1 indicates that date is a holiday).</P> <P>=sum({&lt; Date={"$(=date(today()-2))"}, IsHoliday={1} &gt;} 1)&nbsp;</P> <P>if that's &gt; 0, today - 2 = holiday.</P> Mon, 15 Nov 2021 23:04:34 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/1859631#M1216081 stevejoyce 2021-11-15T23:04:34Z https://community.qlik.com/t5/QlikView/Need-help/m-p/1859819#M1216082 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/156502">@liziegarb</a></P><P>&nbsp;</P><P>I will move this post to the QlikView App Dev thread.</P> Tue, 16 Nov 2021 10:50:08 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/1859819#M1216082 Maria_Halley 2021-11-16T10:50:08Z