topic Re: Calculation Prior Year by selected Month in QlikView

Calculation Prior Year by selected Month

Fri, 13 Jun 2014 02:17:30 GMT

Hi Guys,

Please help me..

How to write script, if I want to see prior year by selected Month.

for example:

If I click Year 2014 and Month May then Summary Jun12-May13

If I click Year 2014 and Month April then summary May12-Apr13

and I've script YTD : sum({<YEAR=, MONTH=, DATE={">=$(MonthStart(Max(Date),-11))<=$(=Max(Date))"},[Field].

Thanks for help.

Regards.

Fri, 13 Jun 2014 02:46:57 GMT

Somebody help me... (T_T)....

Fri, 13 Jun 2014 11:39:48 GMT

Hello Valdi,

I guess you want sum(one-year data) of prior year of current selection, and the following one works.

=sum({$1 <Year={'<=$(=(max(Year)-1))'}, Month=,[Date] = {'<=$(=AddYears(max([Date]),-1))>=$(=Addmonths(max([Date]),-23))'}>} [Field])