topic Re: Max Date from Rolling selection in QlikView https://community.qlik.com/t5/QlikView/Max-Date-from-Rolling-selection/m-p/665210#M242137 <HTML><HEAD></HEAD><BODY><P>expression used for textbox</P><P></P><P>=if(GetPossibleCount(YearMonth)=1, Comment, </P><P>subfield(concat(distinct Comment, '@', -YearMonth),'@') )</P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67387_1.png" style="max-width: 620px;" /></P></BODY></HTML> Mon, 22 Sep 2014 23:31:00 GMT maxgro 2014-09-22T23:31:00Z Max Date from Rolling selection https://community.qlik.com/t5/QlikView/Max-Date-from-Rolling-selection/m-p/665209#M242136 <HTML><HEAD></HEAD><BODY><P>Hi<BR />I have a list box with the Field MonthYear<BR />It has data as follows</P><P>MAr-13</P><P>Apl-13</P><P>May-13</P><P>Jun-13</P><P>.</P><P>.</P><P>.</P><P>Aug-14</P><P></P><P></P><P>And I have a field <!-- which has comments for each date</p><p>Now my requirement is to have a text box which will show the comment with the following logic</p><p></p><p>if a selection is made show the comment for that date.</p><p>If multiple dates are selected show the comment for the largest date eg if jun14-aug 14 is selected show the comments for just aug 14</p><p></p><p>Can any1 help me with this</p></body> --></P></BODY></HTML> Mon, 22 Sep 2014 17:56:20 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-Rolling-selection/m-p/665209#M242136 2014-09-22T17:56:20Z Re: Max Date from Rolling selection https://community.qlik.com/t5/QlikView/Max-Date-from-Rolling-selection/m-p/665210#M242137 <HTML><HEAD></HEAD><BODY><P>expression used for textbox</P><P></P><P>=if(GetPossibleCount(YearMonth)=1, Comment, </P><P>subfield(concat(distinct Comment, '@', -YearMonth),'@') )</P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67387_1.png" style="max-width: 620px;" /></P></BODY></HTML> Mon, 22 Sep 2014 23:31:00 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-Rolling-selection/m-p/665210#M242137 maxgro 2014-09-22T23:31:00Z Re: Max Date from Rolling selection https://community.qlik.com/t5/QlikView/Max-Date-from-Rolling-selection/m-p/665211#M242138 <HTML><HEAD></HEAD><BODY><P>Worked perfectly TY</P></BODY></HTML> Mon, 22 Sep 2014 23:47:42 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-Rolling-selection/m-p/665211#M242138 2014-09-22T23:47:42Z