topic Re: Week to Date in App Development

Week to Date

Anonymous — Mon, 24 Sep 2018 18:18:20 GMT

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.

Re: Week to Date

hectorgarcia — Mon, 24 Sep 2018 18:31:04 GMT

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

I hoe you find it helpfull

Re: Week to Date

justinphamvn — Tue, 25 Sep 2018 03:29:00 GMT

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.