topic Re: Selecting multiple dates in QlikView

Selecting multiple dates

Tue, 21 Jan 2014 17:20:35 GMT

Hello,

I was wondering, if its possible to select a month on a calendar, and do a trigger that would select all the dates from that month and smaller ones?

Any ideas?

Do i make myself clear?

thanks

Re: Selecting multiple dates

Nicole-Smith — Tue, 21 Jan 2014 17:24:30 GMT

Doesn't this solution from before work for you? Selecting Dates

Re: Selecting multiple dates

Tue, 21 Jan 2014 17:29:03 GMT

Its different now, I solved one problem with last time solution, but now its different.

I have a table with the Field Date.

Using that field, i create a calendar table with all the months and days.

Now i want to be able to click a month or a day from this calendar table and have the selection of the date.

Is this possible?

Re: Selecting multiple dates

Carlos_Reyes — Tue, 21 Jan 2014 17:41:34 GMT

An alternative would be to use Set Analysis. Something like the next:

Sum ( { $ < DateField = { " <= $(= Max( DateField ) ) " } > } AmountField)

So... it doesn't matter if you select only one date, the complete month or several months, this set analysis will consider all dates smaller than the max selected or possible date.

Re: Selecting multiple dates

Tue, 21 Jan 2014 17:43:49 GMT

Could you specify more?

Im imagining thats the search string on the triger at the month field?

Re: Selecting multiple dates

Tue, 21 Jan 2014 17:46:50 GMT

And what you mean by amount field?

Re: Re: Selecting multiple dates

Carlos_Reyes — Tue, 21 Jan 2014 18:02:42 GMT

Review the attached. I made an example of my previous suggestion.

Hope it helps!

Re: Selecting multiple dates

Fri, 24 Jan 2014 16:47:34 GMT

Hello, I was wondering if you could aid me with the syntax if i want it to be in a range of date, like <= max date but also bigger than today.

thanks

Re: Selecting multiple dates

Carlos_Reyes — Fri, 24 Jan 2014 16:55:25 GMT

Mmm...

I'm not so sure about your range... because it'll only be possible if you have dates ahead of today, but if you do, then this will do it.

Sum ( {$< Date={"> $(=Today()) <=$(=Max(Date))"}, MonthYear=>} Amount)

Hope it's useful.