topic Re: Monday to Friday in QlikView https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020257#M930405 <HTML><HEAD></HEAD><BODY><P>Use </P><P></P><P>=FirstWorkDate(Today()-1,1)</P><P></P><P>to retrieve the previous working day.</P></BODY></HTML> Mon, 07 Mar 2016 17:12:09 GMT swuehl 2016-03-07T17:12:09Z Monday to Friday https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020255#M930403 <HTML><HEAD></HEAD><BODY><P>Hi everyone.</P><P>My problem is that I have an Auto Selection when I open the document, that selects the previous day automatically and a macro send the report also automatically. The problem is that when the weekend is the previous day, the auto select have no data, and the report is not sent correctly.</P><P>My question is if is there any code to auto select the friday when is monday,insted the sunday so I dont have to re-send the reports manually every week.</P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020255#M930403 diego_vazquez 2020-11-25T16:16:04Z Re: Monday to Friday https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020256#M930404 <HTML><HEAD></HEAD><BODY><P>Hi Diego, I think that if you modified your macro code you could achive this. Could you please post the macro code to have a look.</P><P></P><P>Cheers,</P><P>Andrés</P></BODY></HTML> Mon, 07 Mar 2016 17:05:58 GMT https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020256#M930404 andrespa 2016-03-07T17:05:58Z Re: Monday to Friday https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020257#M930405 <HTML><HEAD></HEAD><BODY><P>Use </P><P></P><P>=FirstWorkDate(Today()-1,1)</P><P></P><P>to retrieve the previous working day.</P></BODY></HTML> Mon, 07 Mar 2016 17:12:09 GMT https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020257#M930405 swuehl 2016-03-07T17:12:09Z Re: Monday to Friday https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020258#M930406 <HTML><HEAD></HEAD><BODY><P>Thank you very much swuehl, that worked!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>swuehl escribió:</P> <P></P> <P>Use</P> <P></P> <P>=FirstWorkDate(Today()-1,1)</P> <P></P> <P>to retrieve the previous working day.</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE></BODY></HTML> Wed, 09 Mar 2016 09:14:33 GMT https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020258#M930406 diego_vazquez 2016-03-09T09:14:33Z Re: Monday to Friday https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020259#M930407 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the Correct Answer.</P><P>If not, please make clear with what part of your question you still need help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Wed, 09 Mar 2016 11:55:21 GMT https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020259#M930407 oknotsen 2016-03-09T11:55:21Z Re: Monday to Friday https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020260#M930408 <HTML><HEAD></HEAD><BODY><P>thank you for the advise!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Wed, 09 Mar 2016 12:07:19 GMT https://community.qlik.com/t5/QlikView/Monday-to-Friday/m-p/1020260#M930408 diego_vazquez 2016-03-09T12:07:19Z