3 Replies Latest reply: Dec 4, 2012 8:09 AM by Roberto Postma

# Quick Set Analysis Question

I am using this set expression...

[FirstDate Date]=,[FirstDate Day]=,[FirstDate Weekday]=,[FirstDate Year]=,[FirstDate Month]=,[FirstDate Quarter]=,[FirstDate _MonthSerial]=,[FirstDate _QuarterSerial]=,[FirstDate _WeekSerial]=,[FirstDate Year-Month]=,

[FirstDate Date] = {"<=\$(=AddYears(Max([FirstDate Date]), -1))"},

[FirstDate Date] = {">=\$(=AddYears(Min([FirstDate Date]), -1))"}

It's supposed to give me records related to the currently selected date range minus 1 year. But it is bringing back the whole year. I need the equivalent of a logical AND...

Any ideas?

Thank you

• ###### Re: Quick Set Analysis Question

You can try this

[FirstDate Date]=,

[FirstDate Day]=,

[FirstDate Weekday]=,

[FirstDate Year]=,

[FirstDate Month]=,

[FirstDate Quarter]=,

[FirstDate _MonthSerial]=,

[FirstDate _QuarterSerial]=,

[FirstDate _WeekSerial]=,

[FirstDate Year-Month]=,

[FirstDate Date] = {">=\$(=AddYears(Min([FirstDate Date]), -1))<=\$(=AddYears(Max([FirstDate Date]), -1))"}

E.g. combine those expression in 1 field...

• ###### Re: Quick Set Analysis Question

Perfect, thanks!

• ###### Re: Quick Set Analysis Question

You're welcome. Happy Qliking!