topic Re: Trigger - QuarterYear in QlikView https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103559#M365705 <HTML><HEAD></HEAD><BODY><P>in the textbox.</P></BODY></HTML> Thu, 23 Jun 2016 18:21:44 GMT krishnacbe 2016-06-23T18:21:44Z Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103557#M365703 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm attempting to create a trigger on sheet activate to select the Max CalendarQuarterYear, which in the data is formated as 'Q1-2016'.&nbsp; When I try adding the field CalendarQuarterYear and Search String as Max(CalendarQuarterYear), or MaxString(CalendarQuarterYear) it doesn't work correctly.&nbsp; </P><P></P><P>When I add MaxString(CalendarQuarterYear) to a textbox to see the result it doesn't give the latest quarter and year in the data set it gives the selected since the field is always one selected.</P></BODY></HTML> Thu, 23 Jun 2016 18:16:51 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103557#M365703 NickHoff 2016-06-23T18:16:51Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103558#M365704 <HTML><HEAD></HEAD><BODY><P>try with Max({&lt;CalendarQuarterYear=&gt;}CalendarQuarterYear)</P></BODY></HTML> Thu, 23 Jun 2016 18:21:28 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103558#M365704 krishnacbe 2016-06-23T18:21:28Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103559#M365705 <HTML><HEAD></HEAD><BODY><P>in the textbox.</P></BODY></HTML> Thu, 23 Jun 2016 18:21:44 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103559#M365705 krishnacbe 2016-06-23T18:21:44Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103560#M365706 <HTML><HEAD></HEAD><BODY><P>It provides no results.</P><P></P><P><IMG alt="2016-06-23_13-23-40.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/129001_2016-06-23_13-23-40.png" style="height: 351px; width: 620px;" /></P></BODY></HTML> Thu, 23 Jun 2016 18:25:07 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103560#M365706 NickHoff 2016-06-23T18:25:07Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103561#M365707 <HTML><HEAD></HEAD><BODY><P>Try with below expression</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">MaxString</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">CalendarQuarterYear</SPAN><SPAN style="font-size: 8pt;">=&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">CalendarQuarterYear</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Thu, 23 Jun 2016 18:33:30 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103561#M365707 krishnacbe 2016-06-23T18:33:30Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103562#M365708 <HTML><HEAD></HEAD><BODY><P>Provides the same results as MaxString(CalendarQuarterYear) which is Q4-2015, the same as the always one selected.</P><P></P><P><IMG alt="2016-06-23_13-35-22.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/129020_2016-06-23_13-35-22.png" style="height: 260px; width: 620px;" /></P></BODY></HTML> Thu, 23 Jun 2016 18:36:12 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103562#M365708 NickHoff 2016-06-23T18:36:12Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103563#M365709 <HTML><HEAD></HEAD><BODY><P>No MaxString(CalendarQuarterYear) is different from MaxString({&lt;CalendarQuarterYear=&gt;}CalendarQuarterYear)</P><P>in second expression I am eliminating the selection in CalendarQuarterYear.</P><P></P><P>see the attached file.</P><P></P><P>share me sample file and expected output.</P></BODY></HTML> Thu, 23 Jun 2016 18:44:23 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103563#M365709 krishnacbe 2016-06-23T18:44:23Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103564#M365710 <HTML><HEAD></HEAD><BODY><P>I know Krishnapriya I tried with both.&nbsp; I just noticed when I select a month the date changes to the maxstring.&nbsp; But, month isn't required to be selected. </P><P></P><P><IMG alt="2016-06-23_13-46-50.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/129021_2016-06-23_13-46-50.png" style="height: 168px; width: 620px;" /></P></BODY></HTML> Thu, 23 Jun 2016 18:47:12 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103564#M365710 NickHoff 2016-06-23T18:47:12Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103565#M365711 <HTML><HEAD></HEAD><BODY><P>This will show what's happening more clearly.<IMG alt="2016-06-23_13-49-00.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/129022_2016-06-23_13-49-00.png" style="height: 197px; width: 620px;" /></P><P></P><P><IMG alt="2016-06-23_13-49-38.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/129023_2016-06-23_13-49-38.png" style="height: 188px; width: 620px;" /></P></BODY></HTML> Thu, 23 Jun 2016 18:50:42 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103565#M365711 NickHoff 2016-06-23T18:50:42Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103566#M365712 <HTML><HEAD></HEAD><BODY><P>Try excluding the Month selection in your expression</P></BODY></HTML> Thu, 23 Jun 2016 18:57:17 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103566#M365712 krishnacbe 2016-06-23T18:57:17Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103567#M365713 <HTML><HEAD></HEAD><BODY><P>Doesn't work.</P></BODY></HTML> Thu, 23 Jun 2016 18:59:42 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103567#M365713 NickHoff 2016-06-23T18:59:42Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103568#M365714 <HTML><HEAD></HEAD><BODY><P>Hope the attached one helps you.</P></BODY></HTML> Thu, 23 Jun 2016 19:05:11 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103568#M365714 krishnacbe 2016-06-23T19:05:11Z Re: Trigger - QuarterYear https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103569#M365715 <HTML><HEAD></HEAD><BODY><P>It doesn't work in my application.</P></BODY></HTML> Thu, 23 Jun 2016 19:07:39 GMT https://community.qlik.com/t5/QlikView/Trigger-QuarterYear/m-p/1103569#M365715 NickHoff 2016-06-23T19:07:39Z