topic Re: Why does my Set Analysis respond to selections even though it includes ignore fields specified? in QlikView

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

jblomqvist — Wed, 23 Sep 2015 15:11:13 GMT

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 — Wed, 23 Sep 2015 15:16:23 GMT

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

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

jblomqvist — Wed, 23 Sep 2015 15:38:56 GMT

Thank you Swuehl you are a star!