Quick Set Analysis Question

[johnso2080]

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

[#2 · Accepted solution]

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...

[johnso2080]

Perfect, thanks!

[#4]

You're welcome. Happy Qliking!