Date From To from SQL View

[#1]

Hi i am a novice at this so looking for some very basic help!

I am loading a SQL view into QlikView with the following:

SQL SELECT *

FROM MobileQC.dbo."QC NEW Banana Report View";

There are over 150 fields in the view, one of which is DateTime.

This field is DD/MM/YYYY HH:MM:SS

I would like to use this a s Date From To option on the report, but i am not sure how to??

Can anyone help?

Thanks

[bbi_mba_76]

Hi,

if I'm right do you want to have a listbox with the date and the reload will take the selection to filter data.

If so you could store the selected date from in a variable and then use the where clause to filter the data (you have to set a default for the variable in case of no selection)

[#3]

Hi Michele, thanks for replying.

I am actually looking to create two fields on the report in Calendar mode.

First field will be the 'from date' and the second field 'Date To'. Both fields would have to use the 'DateTime' field in my extract.

I would like the user to select the from date from the drop down calendar, then the 'Date To' from the drop down calendar. Once done then the table below should be filtered according to these two selections.

Does that make sense?

Thanks again for replying

[mdmukramali · Accepted solution]

Dear Kevin,

As i understood you are looking Range selection of Dates.

follow the below link

http://community.qlik.com/thread/67712

i hope it will help you.

Thanks,

Mukram.

[bbi_mba_76]

Maybe you could use two inputbox to have the two dates. Otherwise you have to duplicate the original field and have two listboxes, one for the from date the other for the to date.

[Gysbert_Wassenaar]

See this tutorial: Selecting Arbitrary Date Ranges

[#7]

Thanks everyone, the video was perfect for showing me how it should be done.

Thanks for all of your help