WTD calculation

[#1]

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?

[Gysbert_Wassenaar]

So my week to date means thursday to thursday business days?

Yes, it does.

Maybe you should read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[rustyfishbones · Accepted solution]

try this in the script

I have attached the file also

[#4]

THanks this serves the purpose exactly the way needed.

[#5]

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. @

Re: WTD calculation

RustyFishBones

how should i do be using this Field week_Fr_to_Th while writing a set analysis for the WTD?