topic LastWorkDate function in QlikView https://community.qlik.com/t5/QlikView/LastWorkDate-function/m-p/1427585#M811401 <HTML><HEAD></HEAD><BODY><P>I'm encountering some difficulties with LastWorkDate while i try to sum variable number of days.</P><P></P><P>it works in this way:</P><P></P><P>LastWorkDate(today(),4)</P><P></P><P>but not</P><P></P><P>LastWorkDate(today(),[Giorni di copertura della giacenza])</P><P></P><P></P><P>In this second versione [Giorni di copertura della giacenza] is a variable calculated.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT cuniberto 2020-11-25T16:16:04Z LastWorkDate function https://community.qlik.com/t5/QlikView/LastWorkDate-function/m-p/1427585#M811401 <HTML><HEAD></HEAD><BODY><P>I'm encountering some difficulties with LastWorkDate while i try to sum variable number of days.</P><P></P><P>it works in this way:</P><P></P><P>LastWorkDate(today(),4)</P><P></P><P>but not</P><P></P><P>LastWorkDate(today(),[Giorni di copertura della giacenza])</P><P></P><P></P><P>In this second versione [Giorni di copertura della giacenza] is a variable calculated.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/LastWorkDate-function/m-p/1427585#M811401 cuniberto 2020-11-25T16:16:04Z Re: LastWorkDate function https://community.qlik.com/t5/QlikView/LastWorkDate-function/m-p/1427586#M811402 <HTML><HEAD></HEAD><BODY><P>May be try this?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">LastWorkDate(today(), <STRONG style="color: #ff6600;">'$([Giorni di copertura della giacenza])'</STRONG>)</SPAN></P></BODY></HTML> Wed, 27 Sep 2017 15:51:41 GMT https://community.qlik.com/t5/QlikView/LastWorkDate-function/m-p/1427586#M811402 vishsaggi 2017-09-27T15:51:41Z