Advanced Select Question

[#1]

Hello,

I'm looking at Year over Year data so, Given 2 date fields like

1. Month Name

2. Day of the Month

I'd like to be able to select for example:

(Jan thru Oct) AND (Nov and Days 1 thru 10)

I don't want:

(Jan thru Oct) AND (Days 1 thru 10)

because I'll only get the first 10 days of each month. Is there a way to nest conditions

in qlikview ? I have a workaround where I use MMDD and ranges but it's not very elegant imo.

Thanks in advance !

Tim

[#2]

As far as I know, there is no way for an end user to 'nest' selections.

You can do it in set analysis, however, but that's not going to solve your problem.

One option would be to allow users to enter their own date parameters into variables, and handle them via expressions/set analysis.

[johnw]

I'd stick with the workaround.

I was thinking you could enter an advanced search expression in a search object, something like this:

=Month <= 10 or (Month = 'Nov' and Day <= 10)

But it doesn't appear that search objects support advanced search expressions? Can anyone confirm?

[#4]

One way of doing it is to create two sliders from "date" that you decouple form the data model. Then you link each slider to a variable, call them mindate and maxdate for example. (by decoupling the fields you can make a selection on a date without it affecting the rest of the application)

Then you can use set analysis {<{">=$(mindate)<$(maxdate)" }>}

In this way you do a selection from start to end date instead and allow the user to make the selection.

[Anonymous]

Tim,
Looks like you need InYearToDate() function.