I have a qlikview report in which i am displaying some records in the straight table..
Here I have two calender objects to select the period. By default the calender objects will be set with max date from the data base.
My requirement is given below.
The max(date) availabel in the data is 7-aug-2013.
When the report is opened, the calenders will be set with 7-aug-2013(Means that one day data will be displayed in the straight table).
After the report is opened, user made some selections in the calender. for example user selected 27-July-2013.
After that when the user clears the selection, the calender will show 27-july-2013 ,because that is the last selected value.
'Clear' action is not clearing the calender obeject.
Now the my customer requirement is that when the user makes some selection and after that if he clear the selction the calender objects should be set with the max date availabel in the data set, it should not be set with the latest selection made.
The thing should be noticed here is that I don't have any button for 'Clear' action. User has to use the default 'clear' which is avilable in the qlikview application.
Means whatever the selction made by the user, finaly when he clear the selection, the calenders should be set with max of date.
Hope you guys understand my requirement.Please advise me with your comments