2 Replies Latest reply: Jun 29, 2018 2:23 PM by Liam Grover RSS

    Get WTD Data from Wednesday to today.

    Liam Grover

      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!