topic Triggers on open in QlikView https://community.qlik.com/t5/QlikView/Triggers-on-open/m-p/785146#M1297822 <HTML><HEAD></HEAD><BODY><P>I have set the field to CY2015-Q1 so that I can see it selected on opening the document.</P><P>I want it to select itself on it's own at every quarter. eg:- It should change to CY2015-Q2 when the date today is 4/1/2015.</P><P>Can I use today() here? any input is appreciated.</P><P></P><P></P><P></P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/75242_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT rdsuperlike 2026-01-26T18:19:17Z Triggers on open https://community.qlik.com/t5/QlikView/Triggers-on-open/m-p/785146#M1297822 <HTML><HEAD></HEAD><BODY><P>I have set the field to CY2015-Q1 so that I can see it selected on opening the document.</P><P>I want it to select itself on it's own at every quarter. eg:- It should change to CY2015-Q2 when the date today is 4/1/2015.</P><P>Can I use today() here? any input is appreciated.</P><P></P><P></P><P></P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/75242_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Triggers-on-open/m-p/785146#M1297822 rdsuperlike 2026-01-26T18:19:17Z Re: Triggers on open https://community.qlik.com/t5/QlikView/Triggers-on-open/m-p/785147#M1297826 <HTML><HEAD></HEAD><BODY><P>I'd rather use ReloadTime() than today(), especially if reload is not every day.&nbsp; Search String will be:</P><P></P><P><SPAN style="font-size: 8pt;">='CY' &amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">year</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ReloadTime</SPAN><SPAN style="font-size: 8pt;">()) &amp; ' - Q' &amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ceil</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">month</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ReloadTime</SPAN><SPAN style="font-size: 8pt;">())/3) </SPAN></P></BODY></HTML> Tue, 13 Jan 2015 18:59:24 GMT https://community.qlik.com/t5/QlikView/Triggers-on-open/m-p/785147#M1297826 Anonymous 2015-01-13T18:59:24Z