topic Alternative to triggers? in QlikView

Alternative to triggers?

danielact — Thu, 23 May 2013 19:30:08 GMT

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.

Re: Alternative to triggers?

marcus_sommer — Fri, 24 May 2013 11:59:27 GMT

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

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

- Marcus

Re: Alternative to triggers?

danielact — Fri, 24 May 2013 15:26:41 GMT

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.

Re: Alternative to triggers?

marcus_sommer — Mon, 27 May 2013 06:17:47 GMT

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