topic Re: Date From To from SQL View in QlikView

Date From To from SQL View

Wed, 09 Oct 2013 09:19:36 GMT

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

Re: Date From To from SQL View

bbi_mba_76 — Wed, 09 Oct 2013 13:54:46 GMT

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)

Re: Date From To from SQL View

Wed, 09 Oct 2013 13:59:50 GMT

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

Re: Date From To from SQL View

mdmukramali — Wed, 09 Oct 2013 14:18:18 GMT

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.

Re: Date From To from SQL View

bbi_mba_76 — Wed, 09 Oct 2013 14:19:55 GMT

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.

Re: Date From To from SQL View

Gysbert_Wassenaar — Wed, 09 Oct 2013 15:36:24 GMT

See this tutorial: Selecting Arbitrary Date Ranges

Re: Date From To from SQL View

Thu, 10 Oct 2013 08:58:05 GMT

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

Thanks for all of your help