topic Re: Calender Object in QlikView

Calender Object

Mon, 17 Jun 2013 11:09:09 GMT

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

Re: Calender Object

Mon, 17 Jun 2013 11:11:24 GMT

Is field event trigger works?

If so how to write the action?

Re: Calender Object

sujeetsingh — Tue, 18 Jun 2013 06:19:50 GMT

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

Re: Calender Object

Tue, 18 Jun 2013 06:29:01 GMT

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

Re: Calender Object

sujeetsingh — Tue, 18 Jun 2013 06:39:45 GMT

Sorry iam not bale to get .

What you want?

What field is used in calender object?

Re: Calender Object

Tue, 18 Jun 2013 06:49:40 GMT

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

Re: Calender Object

Tue, 18 Jun 2013 06:51:08 GMT

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

Re: Calender Object

Tue, 18 Jun 2013 07:04:10 GMT

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

Re: Calender Object

Tue, 18 Jun 2013 07:07:25 GMT

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

Re: Calender Object

Tue, 18 Jun 2013 07:07:47 GMT

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

Re: Calender Object

Tue, 18 Jun 2013 07:09:34 GMT

Dear Ek tha

Please check the attached images

In Img1 i selected 28 Apr 2013 in calender which is a sunday and has data

In Img2 I selected 17 Apr 2013 in calender which is not a sunday and doesn't have data.However the requirement is selection should automatically move to the sunday of that week i.e 14 Apr 2013.

Hope this helps for your clear understanding.

Regards

Murali krishna

Re: Calender Object

Tue, 18 Jun 2013 07:21:52 GMT

Hi karthik

I have date field which has data for only week starts like this

02/06/2013

09/06/2013

16/06/2013

23/06/2013

30/06/2013

I think no need to use the trigger which you have mentioned,

I am using the same field in the calender but it is displaying all the dates for the selection.That is the problem

Regards

Murali Krishna

Re: Calender Object

Tue, 18 Jun 2013 09:02:27 GMT

Thats how its defined by default.

It will show dates between minimum of that field and Maximum of that field.

But It won't allow to select irrelevant date..

Karthik

Re: Calender Object

Tue, 18 Jun 2013 09:45:09 GMT

Hi Karthik

In my case calender is allowing to select all the dates even though data is there for only sundays.Please check the above attached images in this discussion.

Please let me know if any other information is needed.

Regards

Murali Krishna

Re: Calender Object

Tue, 18 Jun 2013 09:49:00 GMT

could you share your document?

Re: Calender Object

Tue, 18 Jun 2013 10:35:42 GMT

Hi Karthik

Sorry i couldn't share my document,

Your right that calender won't allow to select irrelevant date.My reqirement is if the end user selects some irrelevent date selection should automatically move to the relevent date i.e sunday(start of every week in which data is present)

Is it possible in qlikview?

Many thanks for your patience help.

Regards

Murali Krishna

Re: Calender Object

Tue, 18 Jun 2013 10:40:21 GMT

Yes..

By default thats should happen.. If end user try to select irrelevant date (Any client) then it will automaticaly

select last availabe date (less than date which he tried to select)..

Karthik

Re: Calender Object

Tue, 18 Jun 2013 11:48:37 GMT

Hi karthik

But that is not happening in my application

Please check the attached images

In Img1 I selected 28 Apr 2013 in calender which is a sunday and has data.

In Img2 I selected 17 Apr 2013 in calender which is not a sunday and doesn't have data.As you said selection should automatically move to last availabe date i.e 14 Apr 2013 ,But it is retaining at last selected date only i.e 28 Apr 2013.

Regards

Murali krishna

Re: Calender Object

Tue, 18 Jun 2013 12:12:59 GMT

Yes you are right..

My mistake ..

Its selecting automatically last selected date..

Re: Calender Object

Tue, 18 Jun 2013 12:34:09 GMT

Is there any way to automatically move the selections from irrelevant date to relevant date?

Is this possible in QlikView?

Murali Krishna