Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Highlighted
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.