Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
please can anyone help me in solving the below issue?
I have a calender object with many dates.I want to link a trigger to this to set a default date to this calender object.
(some formula abc stored in a variable)
Use another trigger. Field Event Trigger->On Change->Select in Field->Date1, search string:
=MonthStart(AddMonths(Today(),1))
can anyone please help me out for the above issue??????????????????????????????????????????????????????????
Depends on how you created the calendar. Is there a field? ..? Better, try to post your sample qvw.
Hi Tresesco,
sorry may be my question was confusing,I will make my question much clearer.
You can check the below eg file attched for my doubt
Here the calender object consists of a field called'date1' so all the dates are shown and we can select it to whatever we want.
Now I want a default date to be set for the same as the "first day of the next month" which can be achieved by the formula
MonthStart(AddMonths(Today(),1))) .
But how to do this??? I want the default date always to be shown when I open the application but the list of other dates also should be available for a user to check for which ever date he/she wants to.
Please can you help me now in resolving this?????????????????
Create 'On Open' trigger ->Select in Field->... like attached sample
Hi Tresesco,
Thanks for the resolution.Is it possible to make this default?? because when I do a clear everything goes off,which should not happen here and default date should be still visisble .Can this be possible???
Select a date from Date1 field, then right click->list box properties->general tab-> Select 'Always One Value Selected'.
hi,
Yes it works,thanku ....
but after selecting some other date and then if I click clear it does not return back to the default date calculated it remaons in the same date whatever is selected.can this also be made possible????
on opening file and at the first clear when its showning default itself this is working but not when some other date is selected
Use another trigger. Field Event Trigger->On Change->Select in Field->Date1, search string:
=MonthStart(AddMonths(Today(),1))
Thanks a lottttttt Tresesco....
Thanks for patiently teaching me something new... I have learnt something new in Qlikview today