topic DOUCUMENT TRIGGER in QlikView

DOUCUMENT TRIGGER

AVINASH22 — Mon, 26 Jan 2026 16:26:21 GMT

In my dashboard i have 5 years of data.Requirements is that on open the dashboard, recent year data and previous year data is to be selected...so how to implement this by using trigger.

Re: DOUCUMENT TRIGGER

Claudiu_Anghelescu — Sat, 30 Mar 2019 22:39:33 GMT

1. Create 2 variables:

max1=max(Year)

max2= max(Year)-1

2. Trigger -> Select in field:

Year

='(' & $(max1) & '|' & $(max2) & ')'

See my attached sample.