Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I came across this expression for calculating YTD where MonthID =AutoNumber(Year & NUM(Month), 'MonthID')
{$<MonthID = {"<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year = {$(=Max(Year))},
Quarter = ,
Period = ,
PeriodNo = ,
Month = >}
Can someone please explain this expression?
Thanks,
Anju
I think this blog post should explain the syntax quite nicely:
The Magic of Set Analysis – Point In Time Reporting | iQlik - Everything QlikView.
Looks like your syntax is missing.
Hi,
A variable is assigned the value....
vSetYTD={$<MonthID = {"<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year = {$(=Max(Year))},
Quarter = ,
Period = ,
PeriodNo = ,
Month = >}
and an expression is written:
=Sum($(vSetYTD) Win_Flag)