Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

set analysis doubt

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

3 Replies
MVP
MVP

Re: set analysis doubt

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

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

MVP
MVP

Re: set analysis doubt

Looks like your syntax is missing.

Not applicable

Re: set analysis doubt

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)

Community Browser