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

trigger not working in web view/server

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

1 Reply
Nicole-Smith

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