Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Highlighted
AVINASH22
New Contributor

DOUCUMENT TRIGGER

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.

1 Reply
Claudiu_Anghelescu
Contributor III

Re: DOUCUMENT TRIGGER

1. Create 2 variables:

  max1=max(Year)

   max2= max(Year)-1

 

2. Trigger -> Select in field:

 Year

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

 

 

See my attached sample.

To help community find solutions, please don't forget to mark as correct.