topic Re: on open trigger in QlikView

on open trigger

kunkumnaveen — Sat, 12 Mar 2016 09:49:59 GMT

in the trigger ON OPEN

i wrote= max(year) and max(year,2) and max(year,3)

which should select max 3 yr on open...but its not working

thanks

naveen

Kushal_Chawda — Sat, 12 Mar 2016 09:57:36 GMT

Try to change the trigger condition like below

martinpohl — Sat, 12 Mar 2016 10:02:31 GMT

For multi selection you need a '|' between values and brackets around

='('&max(Year)&'|'&(max(Year)-1)&'|'&(max(Year)-2)&')'

Regards