topic Calculating Prior day using formula in QlikView https://community.qlik.com/t5/QlikView/Calculating-Prior-day-using-formula/m-p/650213#M1059751 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate the prior day using variables.</P><P></P><P>What is the best way to do this?</P><P></P><P>I have a table of dates but they are not consecutive as weekends are excluded. If the user select the date for the Monday I would like a variable to calculate the previous day which would be Friday.</P></BODY></HTML> Thu, 02 Oct 2014 13:55:46 GMT alan_grn 2014-10-02T13:55:46Z Calculating Prior day using formula https://community.qlik.com/t5/QlikView/Calculating-Prior-day-using-formula/m-p/650213#M1059751 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate the prior day using variables.</P><P></P><P>What is the best way to do this?</P><P></P><P>I have a table of dates but they are not consecutive as weekends are excluded. If the user select the date for the Monday I would like a variable to calculate the previous day which would be Friday.</P></BODY></HTML> Thu, 02 Oct 2014 13:55:46 GMT https://community.qlik.com/t5/QlikView/Calculating-Prior-day-using-formula/m-p/650213#M1059751 alan_grn 2014-10-02T13:55:46Z Re: Calculating Prior day using formula https://community.qlik.com/t5/QlikView/Calculating-Prior-day-using-formula/m-p/650214#M1059752 <HTML><HEAD></HEAD><BODY><P>try something like </P><P></P><P>=Max({1&lt;Date={"&lt;$(=Date)"}&gt;}Date)</P></BODY></HTML> Thu, 02 Oct 2014 14:01:44 GMT https://community.qlik.com/t5/QlikView/Calculating-Prior-day-using-formula/m-p/650214#M1059752 carvalguil 2014-10-02T14:01:44Z Re: Calculating Prior day using formula https://community.qlik.com/t5/QlikView/Calculating-Prior-day-using-formula/m-p/650215#M1059753 <HTML><HEAD></HEAD><BODY><P>You can use the firstworkdate() function.</P><P><IMG alt="136192.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/68204_136192.png" /></P><P></P><P>If 28/09/2014 is selected (which is a monday), the result is 25/09/2014 (friday).</P></BODY></HTML> Thu, 02 Oct 2014 20:38:13 GMT https://community.qlik.com/t5/QlikView/Calculating-Prior-day-using-formula/m-p/650215#M1059753 geert_gelade 2014-10-02T20:38:13Z