topic Re: Selecting Arbitrary Date Ranges in QlikView

Selecting Arbitrary Date Ranges

Josh_Good — Tue, 04 Dec 2012 16:04:17 GMT

Learn how to make arbitrary date range selections using a from and to date selection.

http://www.youtube.com/watch?v=UTDyO68BYL8

Re: Selecting Arbitrary Date Ranges

Wed, 05 Dec 2012 12:58:49 GMT

First of all thank you for the posted video!

But still I have a problem with my date ranges. It seems like I can select fields on change of variables(Calendar object) using trigger

but I can't do it in other way around... by selecting dates in the field my variables are not changing

Why is that?

I've attached my qvw file.

Re: Selecting Arbitrary Date Ranges

Josh_Good — Fri, 07 Dec 2012 16:24:30 GMT

If found the issue. You had a typo in your variable names for the triggers that were setting the variables when a selections was made on the date field. Under Document Properites -> Triggers I changed the Field Event Triggers for Datums.

You had the variable as: vSakuma Datums when it needs to be vSakumaDatums (no space)

You also had the variable as: vBeigudatums when it needs to be vBeiguDatums (capital 'D')

Hope that helps.

Josh

Re: Selecting Arbitrary Date Ranges

Sun, 09 Dec 2012 14:03:55 GMT

I'm sorry for this misspelling in my test qvw file. I created it in a hurry.

Did you check if it's working without these stupid mistakes?

Can't open this because at home I have only personal edition.

I think this is not my issue... it isn't working for me with correct variable names as well.

If i's working.. pls add corrected file.

And one more question, if I'm selecting one year in listbox, calendar objects will show first and last day of the selected year (for the selected moth respectively)?

Thanks

Re: Selecting Arbitrary Date Ranges

Josh_Good — Mon, 10 Dec 2012 15:48:23 GMT

Yes it does work with the corrections. Here is a copy of the QVW.

-Josh

Re: Selecting Arbitrary Date Ranges

Tue, 08 Jan 2013 16:46:55 GMT

Thank you very much for the post. As a newbie to QlikView I found this straightforward and to the point. Now I wish the QV Community Search would have found it; I had to Google this toppic to find you. The good news is it was at the top of the results. Again, thank you.

Re: Selecting Arbitrary Date Ranges

stevelord — Thu, 08 Aug 2013 21:18:03 GMT

Great video, thanks!

I realized that my firstsortedvalue formulas would pick most current records in the year I selected on my listbox, then not show them if they were outside the variable date range in my inputboxes. This did a beautiful job synchronizing inputbox and listbox and letting the chart expression pull what it's supposed to pull. (I'm working with timestamped records, so it would be excruciating to try to manually select from thousands of timestamps in the listbox. )

Re: Selecting Arbitrary Date Ranges

techvarun — Tue, 10 Sep 2013 07:31:42 GMT

Great Video Thanks

Regards

Re: Selecting Arbitrary Date Ranges

Thu, 26 Sep 2013 14:04:26 GMT

Thanks pretty much for your clear explanation, It's working good!

Re: Selecting Arbitrary Date Ranges

Fri, 28 Feb 2014 19:48:51 GMT

Hi everybody.

I followed the instructions on the video, but have problems with the EndDate. Look what happens:

"Emisión Comprobante" is like the OrderDate in the video.

"Selecciones Actuales" means "Current Selections".

I'm using calendar objects. When selecting the start date, the selection is made. When selecting the end date, nothing changes.

What I'm doing wrong?

Regards.

Damian

Re: Selecting Arbitrary Date Ranges

Josh_Good — Fri, 28 Feb 2014 20:20:29 GMT

Looks like for whatever reason your End Date is coming back in a number format vs date format. Try forcing the search string to come back in the date format. So something like:
='>=' & Date(vStartDate) & '<=' & Date(vEndDate)

I'm writing this on my phone so the syntax might be a bit off - sorry.

Sent from my Commodore 64

Re: Selecting Arbitrary Date Ranges

Fri, 28 Feb 2014 20:33:03 GMT

Just added the Date() for the End Date, and it works. Strange, isn't it?

Regards.

Damian.

Re: Selecting Arbitrary Date Ranges

Tue, 20 Jan 2015 09:49:34 GMT

Dear Josh,

Thanks for the great explaination.

However i am getting an issue in dates.qvw.

When i am opening from server (as a developer) the vBeiguDatums variable works correctly.

But when i am opening as a user from the IIS,i am not able to select the maxdate in calendar object.

Suppose the max date is 1/12/2014,when i am selecting 1/12/2014 in the calendar object it is not letting me select,instead 1/11/2014 is getting selected.

Is this a bug ?

Can you please help me.

Regards,

Rohan

Re: Selecting Arbitrary Date Ranges

Josh_Good — Tue, 20 Jan 2015 15:38:39 GMT

Hi Rohan,

There are may factors that could be at play here depending on your specific qvw and the data in it. There could be an error in the setup that is causing the wrong date to be selected or the date you are trying to select on (1/12/2014) doesn't exist in the data so QlikView is picking a the closest date less than your selection.

To fully help you, I would need to see the QVW. Would you be able to post it or so a version with scrambled data?

-Josh

Qlik

Re: Selecting Arbitrary Date Ranges

Thu, 22 Jan 2015 04:22:14 GMT

Dear Josh,

Thanks for the reply.

However the issue was with the Qlikview setup (server version).

I had qlikview sr9 on my development server whereas on production,it was SR8.

Once upgraded to SR9,the issue no longer exists

One more question regarding the calendar object though,is there a way to set a blank value as defualt in calendar object ?

When a user opens the qlikview report,the calendar object should be blank.

Regards,

Rohan

Re: Selecting Arbitrary Date Ranges

Josh_Good — Thu, 22 Jan 2015 15:40:56 GMT

Hi Rohan,

You can set the document to remove the selections on the calendar upon open. Look under Setting->Document Properties -> Tiggers. Select "OnOpen" and use the "Select in Field" action. By setting the Search String to blank, any selection will be cleared. You may also need to add action to set the variable to blank as well.

-Josh

Qlik

Re: Selecting Arbitrary Date Ranges

Tue, 27 Jan 2015 16:24:23 GMT

Hi Josh

I had already tried this way,but the issue is qlikview recovers sessions,so

if a user does some selection in the calendar and then opens the app again

it starts from where he left,which is not what I want.

I always want the default value in calendar object to be blank.

Is there a way to disable session recovery for certain apps and keeping it

on for the other apps ??

Regards,

Rohan

Re: Selecting Arbitrary Date Ranges

Josh_Good — Tue, 27 Jan 2015 16:37:36 GMT

Hi Rohan,

You can disable Session Recovery in the QMC under System-> Setup ->QlikView Servers ->Documents. Note this is a global setting so it will effect all documents and all users in your enviornment.

-Josh

Qlik

Re: Selecting Arbitrary Date Ranges

fashid — Fri, 13 Feb 2015 07:25:20 GMT

Hi,

I have been struggling to get my date range selections working but i dont understand where i am failing .

If any body could help me with my sample app or a hint where im doing it wrong . !

I would grreatly appreciate it.

Regards,

Nadeem

Re: Selecting Arbitrary Date Ranges

Josh_Good — Mon, 23 Feb 2015 18:49:07 GMT

Hi,

It looks like your expressions are returning the numeric value foe the dates the trigger is not able to select on the CalendarDate field. In other words your expression:

='>= $(vstartdate)<=$(venddate)'

Returns this:

>= 42047<=42039

Use this expression:

='>= $(=Date(vstartdate))<=$(=Date(venddate))'

To Return This:

>= 2/12/2015<=2/4/2015

Hope this helps.

-Josh

Qlik