Excluding a Range Within a Range Using Actions

[#1]

I want an action which selects all data for the year 2016 except for August month.

The following action includes all data (all years) except for August 2016:

'<' & MakeDate(2016,8,1) & '>=' & MakeDate(2016,9,1)

The following action returns all data for 20016 including all data in the future.

='>=' & MakeDate(2016,01,01) & '<' & MakeDate(2016,8,1) & ', >' & MakeDate(2016,8,31) & '<=' & MakeDate(2016,12,31)

The comma doesn't do any changes for the result.

Parantheses are not allowed.

In addtion to this, I've tried almost everything.

Is there a solution to this?

It's way too bad that QlikTech doesn't document the application!

[sunny_talwar · Accepted solution]

Have not tested this, but try this:

='(>=' & MakeDate(2016,01,01) & '<' & MakeDate(2016,8,1) & '|>' & MakeDate(2016,8,31) & '<=' & MakeDate(2016,12,31) & ')'

[#3]

Thank you! The sun is above the horizon!