Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calender Object

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

19 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

could you share your document?

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

Yes you are right..

My mistake ..

Its selecting automatically last selected date..

Not applicable
Author

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

Is this possible in QlikView?

Murali Krishna