set analysis doubt

[#1]

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

[swuehl]

I think this blog post should explain the syntax quite nicely:

The Magic of Set Analysis – Point In Time Reporting | iQlik - Everything QlikView.

[MK_QSL]

Looks like your syntax is missing.

[#4]

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)