Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Regards
Arif
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).
Select in Field: CrimeDate
Search String: Your expression