topic WTD calculation in QlikView https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483268#M180596 <HTML><HEAD></HEAD><BODY><P>In the below app i was trying calculate the week to date of which in qlikview it takes by default monday thru friday but in this app i need to start from last week friday to following week thursday. for example present week # 45 should consider starting from last friday which is 11/01/2013 thru 11/07/2013 this should be my week to date. Please suggest how to arrive to this?</P></BODY></HTML> Tue, 05 Nov 2013 18:35:26 GMT 2013-11-05T18:35:26Z WTD calculation https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483268#M180596 <HTML><HEAD></HEAD><BODY><P>In the below app i was trying calculate the week to date of which in qlikview it takes by default monday thru friday but in this app i need to start from last week friday to following week thursday. for example present week # 45 should consider starting from last friday which is 11/01/2013 thru 11/07/2013 this should be my week to date. Please suggest how to arrive to this?</P></BODY></HTML> Tue, 05 Nov 2013 18:35:26 GMT https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483268#M180596 2013-11-05T18:35:26Z Re: WTD calculation https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483269#M180597 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">So my week to date means thursday to thursday business days?</SPAN></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Yes, it does.</P><P></P><P></P><P></P><P></P><P>Maybe you should read these two documents:</P><UL><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-2380" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">QlikCommunity Tip: How to get answers to your post?</A></LI><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Preparing examples for Upload - Reduction and Data Scrambling</A></LI></UL></BODY></HTML> Tue, 05 Nov 2013 18:42:33 GMT https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483269#M180597 Gysbert_Wassenaar 2013-11-05T18:42:33Z Re: WTD calculation https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483270#M180598 <HTML><HEAD></HEAD><BODY><P>try this in the script</P><P></P><P><IMG alt="2013-11-12_2042.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/48878_2013-11-12_2042.png" /></P><P></P><P>I have attached the file also</P></BODY></HTML> Tue, 12 Nov 2013 21:04:42 GMT https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483270#M180598 rustyfishbones 2013-11-12T21:04:42Z Re: WTD calculation https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483271#M180599 <HTML><HEAD></HEAD><BODY><P>THanks this serves the purpose exactly the way needed.</P></BODY></HTML> Tue, 12 Nov 2013 21:23:39 GMT https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483271#M180599 2013-11-12T21:23:39Z Re: Re: WTD calculation https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483272#M180600 <HTML><HEAD></HEAD><BODY><P>This works but i have an issue. When i am trying to use this in a set analysis to calculate the WTD and the way it does is different. @</P><H6 style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;"><A _jive_internal="true" class="font-color-meta-light" href="https://community.qlik.com/message/420709#420709" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #a9a9a9;">Re: WTD calculation</A></STRONG></H6><P class="j-post-avatar" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" class="j-avatar jiveTT-hover-user" data-avatarid="5859" data-externalid="" data-presence="null" data-userid="69948" data-username="RustyFishBones" href="https://community.qlik.com/people/RustyFishBones" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"><IMG alt="Alan Farrell" border="0" class="jiveImage jive-avatar" data-avatarid="5859" data-height="46" data-username="RustyFishBones" height="46" src="https://community.qlik.com/people/RustyFishBones/avatar/46.png?a=5859" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="46" /></A><SPAN class="j-status-levels" style="font-weight: inherit; font-style: inherit; font-family: inherit;"><IMG alt="Wizard" class="jiveImage" src="https://assets.bunchball.net/badges/levels/L7.png" style="font-weight: inherit; font-style: inherit; font-family: inherit;" title="Wizard" /></SPAN></P><P><SPAN class="j-post-author" style="font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;"><A href="https://community.qlik.com/people/RustyFishBones">RustyFishBones</A></STRONG></SPAN></P><P>how should i do be using this Field week_Fr_to_Th while writing a set analysis for the WTD?</P></BODY></HTML> Tue, 07 Jan 2014 18:45:52 GMT https://community.qlik.com/t5/QlikView/WTD-calculation/m-p/483272#M180600 2014-01-07T18:45:52Z