set analysis using date functions

[#1]

Hi there

Am new to qlikview and am at my witts end on how to solve this set analysis am trying to write i've look around this forum trying solve this but just can't my head around it

Am trying to write a set analysis to sum sales from the first day of the year for last year to yesterdays date last year please see what i currently have any help would be most appreciated

=SUM(

{<

[Calendar Date]=

{

">=$(=DATE(YEARSTART(ADDMONTHS(MAKEDATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()-1)),-12)),'DD/MM/YYYY'))",

"<=$(=DATE(ADDMONTHS(MAKEDATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()-1)),-12),'DD/MM/YYYY'))"

}

>}

TransactionsLine.Price*TransactionsLine.Quantity )

[#2 · Accepted solution]

It Ok i've solved the problem. Had a comma between the date ranges.

=SUM(

{<

[Calendar Date]=

{

">=$(=DATE(YEARSTART(ADDMONTHS(MAKEDATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()-1)),-12)),'DD/MM/YYYY'))"

"<=$(=DATE(ADDMONTHS(MAKEDATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()-1)),-12),'DD/MM/YYYY'))"

}

>}

TransactionsLine.Price*TransactionsLine.Quantity )