topic Re: Max value in the list box in QlikView https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308935#M407086 <HTML><HEAD></HEAD><BODY><P>Is your Type_Period field correctly read as date by qlikview?</P></BODY></HTML> Fri, 30 Jun 2017 15:32:09 GMT sunny_talwar 2017-06-30T15:32:09Z Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308929#M407080 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In the list box of value</P><P>Apr16</P><P>May16</P><P>June16</P><P>Apr17</P><P>Jun17</P><P></P><P>i want to select the max value int he list box</P><P></P><P>i tried to giving the trigger as =max({1}Type_Period) but its not working and not picking the max value as Jun17</P><P></P><P>help me how to do this?</P></BODY></HTML> Fri, 30 Jun 2017 14:41:28 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308929#M407080 manoranjan_d 2017-06-30T14:41:28Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308930#M407081 <HTML><HEAD></HEAD><BODY><P><SPAN><SPAN>Здравствуй,</SPAN></SPAN></P><P></P><P><SPAN><SPAN>Может быть, как в приложенном файле</SPAN></SPAN></P></BODY></HTML> Fri, 30 Jun 2017 14:59:21 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308930#M407081 ahaahaaha 2017-06-30T14:59:21Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308931#M407082 <HTML><HEAD></HEAD><BODY><P>Is your <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Type_Period read as date by QlikView?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></SPAN></P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P></BODY></HTML> Fri, 30 Jun 2017 15:07:00 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308931#M407082 sunny_talwar 2017-06-30T15:07:00Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308932#M407083 <HTML><HEAD></HEAD><BODY><P>hi andrey,</P><P></P><P>i want the max value to be selected in the list list box</P></BODY></HTML> Fri, 30 Jun 2017 15:11:12 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308932#M407083 manoranjan_d 2017-06-30T15:11:12Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308933#M407084 <HTML><HEAD></HEAD><BODY><P>ur file vomit the other values, when user open a file he wants to see the max date in the list box have to be selected, other dates has ti be deselected </P></BODY></HTML> Fri, 30 Jun 2017 15:14:49 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308933#M407084 manoranjan_d 2017-06-30T15:14:49Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308934#M407085 <HTML><HEAD></HEAD><BODY><P>Hi sunny can uhelp me how to do this?</P></BODY></HTML> Fri, 30 Jun 2017 15:15:05 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308934#M407085 manoranjan_d 2017-06-30T15:15:05Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308935#M407086 <HTML><HEAD></HEAD><BODY><P>Is your Type_Period field correctly read as date by qlikview?</P></BODY></HTML> Fri, 30 Jun 2017 15:32:09 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308935#M407086 sunny_talwar 2017-06-30T15:32:09Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308936#M407087 <HTML><HEAD></HEAD><BODY><P>Try this may be:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168748_Capture.PNG" style="height: 527px; width: 620px;" /></P></BODY></HTML> Fri, 30 Jun 2017 15:40:45 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308936#M407087 vishsaggi 2017-06-30T15:40:45Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308937#M407088 <HTML><HEAD></HEAD><BODY><P>No</P></BODY></HTML> Fri, 30 Jun 2017 15:59:24 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308937#M407088 manoranjan_d 2017-06-30T15:59:24Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308938#M407089 <HTML><HEAD></HEAD><BODY><P>Not working naga</P></BODY></HTML> Fri, 30 Jun 2017 16:02:59 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308938#M407089 manoranjan_d 2017-06-30T16:02:59Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308939#M407090 <HTML><HEAD></HEAD><BODY><P>Then first step would be to fix that in the script</P><P></P><P><STRONG>LOAD Date(Alt(Num(Date#(Type_Period,'MMMYY')), </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>Num(Date#(Type_Period,'MMMMYY'))), 'MMMYY') AS Type_Period</STRONG></SPAN></P><P></P><P>and then trigger like this may be</P><P></P><P>Field</P><P><STRONG>Type_Period</STRONG></P><P></P><P>Search String</P><P><STRONG>=Date(Max(Type_Period), 'MMMYY')</STRONG></P></BODY></HTML> Fri, 30 Jun 2017 16:05:23 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308939#M407090 sunny_talwar 2017-06-30T16:05:23Z Re: Max value in the list box https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308940#M407091 <HTML><HEAD></HEAD><BODY><P>It worked for me can you share your app you are trying on?</P></BODY></HTML> Fri, 30 Jun 2017 16:07:00 GMT https://community.qlik.com/t5/QlikView/Max-value-in-the-list-box/m-p/1308940#M407091 vishsaggi 2017-06-30T16:07:00Z