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: 
danielact
Partner - Creator III
Partner - Creator III

Alternative to triggers?

I have an application that tracks insurance policies. Each policy has an effective and expiration date. I have a calendar object where the user can select a date, and it filters to all effective contracts. I do this with a trigger - the calendar is linked to a variable called vInForceDate, and it has a trigger which sets Effective_Date to <=vInForceDate and sets Expiration_Date to >=vInForceDate.

Any idea on how I can do this without triggers so it will work with the AJAX client? I have some users who want to use iPads for it, and you can't use the IE Plugin with it.

3 Replies
marcus_sommer

Perhaps this could work with a set analysis condition in the appropriate formulas:

=Count({1<Expiration_Date={">=$(vInForceDate)"}, Effective_Date={"<=$(vInForceDate)"}>} Contracts)

- Marcus

danielact
Partner - Creator III
Partner - Creator III
Author

I know I can do that in the expressions, but I want my list boxes to update and show what gets filtered out as well.

marcus_sommer

You could use instead a listbox a textbox for showing which date values includes the selection - it is not the same, but it gives users the requieres information.

- Marcus