Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.