topic Advanced Select Question in QlikView

Advanced Select Question

Fri, 12 Nov 2010 22:54:16 GMT

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

Advanced Select Question

Fri, 12 Nov 2010 23:27:12 GMT

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.

Advanced Select Question

johnw — Sat, 13 Nov 2010 00:26:22 GMT

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?

Advanced Select Question

Sat, 13 Nov 2010 18:01:09 GMT

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.

Advanced Select Question

Anonymous — Sat, 13 Nov 2010 19:39:39 GMT

Tim,
Looks like you need InYearToDate() function.