Calender Object

[#1]

Hi All,

I am using calender object for selecting the date.How ever the reqirement is if user selects any date in a particular week automatically selection should move to start of the week i.e sunday.Please suggest me how to do this?

Thanks in advance

Regards

Murali Krishna

[#2]

Is field event trigger works?

If so how to write the action?

[sujeetsingh]

Murli please give a sample and explain in the sample what functionality do you want.

[#4]

Ek tha many thanks for your reply,

I have got a requirement like if the user selects any date in a particular week in a calender object the selection should automatically move to the start of that particular week i.e sunday.This is because data is available for only sundays.

Is this possible in qlikview?

If so suggest me how to do this?

Eagerly waiting for your reply

[sujeetsingh]

Sorry iam not bale to get .

What you want?

What field is used in calender object?

[#6]

I am using the Date (DD/MM/YYYY) field in the calender object.This field has data for only sundays in all the available months.

For example if we consider this month, data will be like this

02/06/2013

09/06/2013

16/06/2013

23/06/2013

30/06/2013

So if the user selects any date in a particular week (since calender will display all the dates) selection should automatically move to a partcular week sunday which has data.

Still if you are not able to get feel free to express.I will try to express in more detailed way

Regards

Murali Krishna

[#7]

Hi Murali, populate your calendar object with the dates only pertaining to sundays. make another field from the date field with function weekstart and store only sunday dates in it and use that field in the calendar object.

Hope that helps.

-Abhinava

[#8]

Hi Abhinava

I have data only for sundays in date field,I am populating the same field to the calender but calender is displaying all the dates for selection.Please check the images attached

[#9]

Hi Murali,

Find Step by step

Go to Docment Properties -->  Triggers --> Field Eventr Triggers --> "Select the field you want to affect"--> "Click Add Action" -->

-->Click "Add" -->  Select "Selection in Field" --> Click "OK" -->  In Field Box typle "{Field_Name}" -->  In Search string type "=WeekStart(LinkDate)"

--> Click "OK" and come back.

Now you can check..

Regards,

Karthik

[#10]

Hi Murali,

Find Step by step

Go to Docment Properties -->  Triggers --> Field Eventr Triggers --> "Select the field you want to affect"--> "Click Add Action" -->

-->Click "Add" -->  Select "Selection in Field" --> Click "OK" -->  In Field Box typle "{Field_Name}" -->  In Search string type "=WeekStart(LinkDate)"

--> Click "OK" and come back.

Now you can check..

Regards,

Karthik