Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
ismqui00
New Contributor III

Week to Date

Example of an expression that will sum values week to date?  I have tried a few expressions, but they do not sum correct date frame or error appears.  Any help is appreciated.  Thanks in advance.

2 Replies
Partner
Partner

Re: Week to Date

justinphamvn
Contributor II

Re: Week to Date

Hi,

You should using Set Analysis

Try like this:

sum(

          {

              <

                date=,

                Year=,

                Month=,

                Quarter=,

                    date={">=$(=WeekStart(Max(date)))<=$(=Max(date))"}

              >

          }

Sales)

Hope this helps,

Justin.