Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

groveliam
Contributor

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
MVP
MVP

Re: Get WTD Data from Wednesday to today.

May be this

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

2 Replies
MVP
MVP

Re: Get WTD Data from Wednesday to today.

May be this

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

groveliam
Contributor

Re: Get WTD Data from Wednesday to today.

That worked, thanks so much!

Community Browser