topic Re: From and To Date in QlikView

From and To Date

Mon, 08 Jul 2013 14:03:13 GMT

Hello Community,

I' am stuck with an issue. I have created two calendar objects. One of them points to StartDate while the other corresponds to EndDate. Things are working fine... but the client wants current week to be shown in the Calendar objects when they open the application.

Example let us say that today is Monday 08-07-2013 tomorrow will be 9th and so on.. when the end user opens the dashboard he/she should see charts based upon current week and also the main part is that the Calander objects should show the dates corresponding to current week.

If we consider period from 1st July to 5th july, then 'From' calander should show 1st july while the other that is 'To' Calander should show 5th July and these should happen when the dashboard opens

Thanks in advance for your help and suggestions

Re: From and To Date

RedSky001 — Mon, 08 Jul 2013 14:48:38 GMT

Create two variables

vStartDate =WeekStart(now())

vEndDate =WeekEnd(now())

Settings > Document Properties > Triggers >

OnOpen Action > Add Action > Add > Action Type "Selection" > Action "Select in Field" > OK >

= '>=$(=vStartDate) <=$(=vEndDate)'

See the attached file.

Re: From and To Date

pennetzdorfer — Mon, 08 Jul 2013 14:50:10 GMT

Use Settings > Document Properties > Triggers > Document Event Triggers > OnOpen

Add a new Action "Select in Field"

Field = Week ...if you don't have a week-field yet, simply create it in script ... week(yourdatefield)
Search String = week(today())

Hope that helps,

Florian

Re: From and To Date

Tue, 09 Jul 2013 07:28:50 GMT

Hi Florian,

Many thanks for your help. Actually my requirement is that I have two calendar objects on the dashboard and user want that when the dashboard is opened, by default the current week Start and end date should be displayed on the Calendar.

You can see from the attchement that there are 2 calendars namely From Date and To Date and this is where we want the current week to be diplayed.

Example for this July month, the current week no. is 28 so the calanders should display 8th on the from Date and 9th on the To Date calanders respectively

Please help

Re: From and To Date

Tue, 09 Jul 2013 07:30:53 GMT

Hi Mark,

I tried your suggestion but it's not working for me.. Actually my requirement is that I have two calendar objects on the dashboard and user want that when the dashboard is opened, by default the current week Start and end date should be displayed on the Calendar.

You can see from the attchement that there are 2 calendars namely From Date and To Date and this is where we want the current week to be diplayed.

Example for this July month, the current week no. is 28 so the calanders should display 8th on the from Date and 9th on the To Date calanders respectively

Please help

Re: From and To Date

pennetzdorfer — Tue, 09 Jul 2013 08:09:10 GMT

I'm not sure if I understand your issue, but if you've got two date fields (StartDate and EndDate) you could try the following:

Use Settings > Document Properties > Triggers > Document Event Triggers > OnOpen

Add two Actions ("Select in Field")

1) Field: StartDate, Search string: =WeekStart(Today())

2) Field: EndDate, Search string: =floor(WeekEnd(Today()))-2

Regards,

Florian

Re: From and To Date

Tue, 09 Jul 2013 08:51:37 GMT

Hi Florian,

I have created two variables vStartWeek and vEndWeek for this purpose

Re: From and To Date

pennetzdorfer — Tue, 09 Jul 2013 09:10:25 GMT

Could you upload a short example qvw that outlines your issue? That would simplify things

Re: From and To Date

Tue, 09 Jul 2013 10:06:43 GMT

Hi Florian,

I'am attaching a sample application for your reference. Here there are two calander objects and the requirement is that we need From calendar to display the starting day of the current week while the other Calendar(To Date) should show the end date of current week on opening of the dashboard.

Thanks for your help in advance.

Re: From and To Date

pennetzdorfer — Tue, 09 Jul 2013 11:02:23 GMT

There are at least two things you should change:

Don't use "=" in front of variable names in Actions
Your "OnAnySelect" triggers override the "OnOpen" triggers --> delete or modify them ...

I adjusted 1) and 2) and the StartDate works now.

Apart from that: I'm wondering if you really need all triggers/variables ... I guess you could simply target the original field Q_CLOSEDDATEFORMAT for your triggers.

Regards,

Florian

Re: From and To Date

Tue, 09 Jul 2013 11:43:57 GMT

Hi,

Thanks for your help Florian. Actually the 1st Calendar 'FROM DATE ' should display the starting date of the current week while the other calendar object should display the current date or todays date of the week. Also the Calendar objects should get clear when Clear All is pressed.

pls provide your inputs.

Re: From and To Date

Wed, 30 Oct 2013 18:48:37 GMT

I have the same problem ...could you provide me your solution

Thanks

Re: From and To Date

Tue, 26 Nov 2013 15:27:31 GMT

Hi,

Sorrry for late reply as I saw your query today.. have you found solution. If not I can send you the solution