topic Re: Quick Set Analysis Question in QlikView

Quick Set Analysis Question

johnso2080 — Tue, 04 Dec 2012 12:43:03 GMT

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

Tue, 04 Dec 2012 12:55:59 GMT

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

johnso2080 — Tue, 04 Dec 2012 13:06:29 GMT

Perfect, thanks!

Re: Quick Set Analysis Question

Tue, 04 Dec 2012 13:09:07 GMT

You're welcome. Happy Qliking!