Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

johnso2080
New Contributor

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

Tags (3)
1 Solution

Accepted Solutions
Not applicable

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

3 Replies
Not applicable

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

johnso2080
New Contributor

Re: Quick Set Analysis Question

Perfect, thanks!

Not applicable

Re: Quick Set Analysis Question

You're welcome. Happy Qliking!

Community Browser