topic Date - Button in QlikView

Date - Button

william_denholm — Thu, 02 Jul 2015 13:09:36 GMT

Hello,

I am looking to create three buttons that will show data for the current day, days 2-6 (ie tomorrow onwards) and then +7 days.

The field is called APPOINTMENTSTART and the data is in the format of

02/07/2015 08:00:00

I have tried to use various combinations of TODAY() etc but none seem to work. Anyone have any ideas?

Thanks.

Re: Date - Button

datanibbler — Thu, 02 Jul 2015 13:19:52 GMT

Hi William,

what data do you want to display using these? Only the date and that time (08:00:00)?

Try (Today()+1)

Re: Date - Button

swuehl — Thu, 02 Jul 2015 13:21:16 GMT

Maybe like attached?

edit: in case you can't open the QVW, here are the search strings for the three button (Action Select-Select in field):

Today:

='>='&daystart(today())&'<='&DayEnd(today())

2-6:

='>='&daystart(today()+1)&'<='&DayEnd(today()+6)

7+:

='>='&daystart(today()+7)

Re: Date - Button

datanibbler — Thu, 02 Jul 2015 13:28:38 GMT

Ah,

I think I misunderstood. Correct me if these assumptions are wrong:

- You have a field calles APPOINTMENTSTART

- That always has the time of 08:00:00 and some date

- You want to display the data of some other fields, automatically selecting on that field APPOINTMENTSTART

If yes, you could possibly do that using set_analysis, but the easiest to implement would probably be putting a selection_trigger ("select in field") on the buttons. For the latter two (2-6 and 7) you will have to use some adanced search_strings. Try that out.

First, though, you will have to split the date_part from your APPOINTMENTSTART.

=> Then, in general

- Click on the listbox of the date_field (or any other, it should work on whichever field through associative search)

- Type sth like >> = [date_of_APPOINTMENTSTART] > (Today()+1) <<

- If you have that search_string in a selection_trigger, you might have to wrap it in quotes.

HTH

Re: Date - Button

sunilkumarqv — Thu, 02 Jul 2015 13:50:56 GMT

Check this

Dynamically Selecting Timeframes

Re: Date - Button

swuehl — Thu, 02 Jul 2015 13:56:22 GMT

In case you have trouble interpreting your APPOINTMENTSTART field correctly, please have a look at

Get the Dates Right

Why don’t my dates work?

Re: Date - Button

william_denholm — Fri, 03 Jul 2015 09:16:10 GMT

Thanks all. Various pieces from the links provided.

Had to set the format of the field as date.

Then created variables for the various options I was looking for.

Added these variables to the button field searches.