topic Re: set analysis doubt in QlikView

set analysis doubt

Thu, 10 Oct 2013 16:45:30 GMT

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

Re: set analysis doubt

swuehl — Thu, 10 Oct 2013 16:53:18 GMT

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

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

Re: set analysis doubt

MK_QSL — Thu, 10 Oct 2013 16:59:05 GMT

Looks like your syntax is missing.

Re: set analysis doubt

Thu, 10 Oct 2013 17:14:57 GMT

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)