Why does my Set Analysis respond to selections even though it includes ignore fields specified?

[jblomqvist]

Hello,

In the Line Graph below you can see it looks at CYTD vs LYTD Sales.

The expressions for the two lines are:

CYTD:

Sum({<Year=, Quarter=, Month=, Week=, Date={'>=$(=YearStart(Max(OrderDate)))<=$(=Max(OrderDate))'}>} Sales)

LYTD:

Sum({<Year=, Quarter=, Month=, Week=, Date={'>=$(=YearStart(Max(OrderDate), -1))<=$(=AddYears(Max(OrderDate), -1))'}>} Sales)

As you can see from the expression there are clauses to ignore selections in fields such as Year, Month etc.

But when I make selections the chart starts responding:

Does anyone know how to change my expression to stop this please?

[swuehl · Accepted solution]

In your expression definitions, use a set identifier 1 in the max() functions:

...Max({1} OrderDate)..

[jblomqvist]

Thank you Swuehl you are a star!