Week to Date

[Anonymous]

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.

[hectorgarcia]

Hi , have you tried this?
https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/i...

I hoe you find it helpfull

[justinphamvn]

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.