set analysis using date functions

Tue, 12 Oct 2010 11:08:37 GMT

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 )

set analysis using date functions

Tue, 12 Oct 2010 12:24:07 GMT

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 )

topic set analysis using date functions in QlikView

set analysis using date functions

set analysis using date functions