Get WTD Data from Wednesday to today.

[groveliam]

Working in Qlik Sense, I am trying to get the number of accounts opened for the last week, but I need the beginning of the week to start from the most recent Wednesday. Currently, I am able to get the past 7 days, but I need the days from Wednesday. For example, if today is Friday, then I would only want the count of new accounts opened Wed - Fri. Below is what I have for getting the last 7 days:

Count({$<[Open DT] = {">=$(=Date(Today()-7, 'MM/DD/YYYY'))"}>}[ACCT NBR])

I will also attach some sample data.

Any help is appreciated!

[sunny_talwar · Accepted solution]

May be this

Count({<[Open DT] = {">=$(=Date(WeekStart(Today(), 0, 2), 'MM/DD/YYYY'))<=$(=Date(Today(), 'MM/DD/YYYY'))"}>} [ACCT NBR])

[groveliam]

That worked, thanks so much!