topic Re: Selecting Dates in QlikView

Selecting Dates

Thu, 16 Jan 2014 19:16:55 GMT

Hello,

Im currently trying to make a multiple date selection by one click.

Let me explain. I want if you click any date, all the dates before that date select aswell.

Anyone got any ideas?

Do i made myself clear?

thanks

Re: Selecting Dates

Nicole-Smith — Thu, 16 Jan 2014 19:26:20 GMT

Example is attached.

Re: Selecting Dates

Thu, 16 Jan 2014 19:34:48 GMT

It works fine ,

But do you think is possible to have it asswell on the day, for example i got my calendar made out of date, and if i select 6 it'll be 6th of december the max date, if i select a month itll be 6 of that month the max date.

Re: Selecting Dates

Nicole-Smith — Thu, 16 Jan 2014 19:43:49 GMT

I'm not sure what you mean...

Re: Selecting Dates

Fri, 17 Jan 2014 16:15:05 GMT

you have your field Date, and if you select any, the smaller values will be selected aswell.

Now, from that field date, I created a calendar, with day, month, year, etc. Month and Day, i have them displayed available for selections, its possible to be able to select the smaller values like we did with the field date, but insted of selecting the field date, i select the field month in my calendar.

I dont want to have the smaller months selected, but when i click May, it'll select the dates from may and smaller.

Do i make myself clear?

Re: Re: Selecting Dates

Nicole-Smith — Fri, 17 Jan 2014 16:38:59 GMT

So you only want the dates for the month selected? If so, see the new trigger on the attached. It should give you what you're looking for.

Trigger is:

=if(GetSelectedCount(Date)>0, '>=' & monthstart(max(Date)) & '<=' & max(Date))