topic Excluding a Range Within a Range Using Actions in QlikView

Excluding a Range Within a Range Using Actions

Wed, 14 Dec 2016 14:27:00 GMT

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 — Wed, 14 Dec 2016 16:44:35 GMT

Have not tested this, but try this:

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

Thu, 15 Dec 2016 07:56:25 GMT

Thank you! The sun is above the horizon!