Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Get WTD Data from Wednesday to today.

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!

1 Solution

Accepted Solutions

May be this

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

View solution in original post

2 Replies

May be this

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

View solution in original post

Creator
Creator

That worked, thanks so much!