I have put the below expression in onanyselect action.
=if(
(GetSelectedCount(CrimeDates)=0) and
(GetActiveSheetId()='Document\SH29' or
GetActiveSheetId()='Document\SH72' or
GetActiveSheetId()='Document\SH73' Or
GetActiveSheetId()='Document\SH05' or
GetActiveSheetId()='Document\SH83'),
date(max({$1}OffenseDateConv), 'M/D/YYYY'),
if(
(GetSelectedCount(CrimeDates)>1) and
(GetActiveSheetId()='Document\SH29' or
GetActiveSheetId()='Document\SH72' or
GetActiveSheetId()='Document\SH73' Or
GetActiveSheetId()='Document\SH05' or
GetActiveSheetId()='Document\SH83'),
date(max(CrimeDates), 'M/D/YYYY'),
GetFieldSelections(CrimeDates)
) )
This basically makes sure that there is always atleast one value selected in the crimedate. If there is no selected value, a max date will be selected. In desktop version, If I click on clear, it select the max date into crime date
However if I put the dashboard on qlikview server or if i select webview in desktop version, clicking the clear button does not select the max value into the crime date. Can someone please explain the reason behind it
I don't know the reason behind it, but this may be a workaround for you...
Try using a Field Event Trigger on the field CrimeDate for the OnSelect action (I know this works on the server and in WebView because I've used this type of trigger before).