topic Re: multiple values for a text box in QlikView https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836234#M1008922 <HTML><HEAD></HEAD><BODY><P>do you have a date ? or another field that you can use to obtain the latest information ?</P><P></P><P>this could be done only({&lt;&gt;})</P><P></P><P></P><P>only({&lt; Date= {"&gt;=$(=(max(Date)))"}&gt;}field)</P></BODY></HTML> Mon, 11 May 2015 18:42:06 GMT ramoncova06 2015-05-11T18:42:06Z multiple values for a text box https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836233#M1008920 <HTML><HEAD></HEAD><BODY><P>hello</P><P></P><P>I have a table that contains multiple records(current and historical) for the same id.&nbsp; I want to only display the current record in the text box.&nbsp; There also can be more than 1 current records, so I really need to show the 1st current record.</P><P></P><P>thanks</P></BODY></HTML> Mon, 11 May 2015 18:22:20 GMT https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836233#M1008920 fcecconi 2015-05-11T18:22:20Z Re: multiple values for a text box https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836234#M1008922 <HTML><HEAD></HEAD><BODY><P>do you have a date ? or another field that you can use to obtain the latest information ?</P><P></P><P>this could be done only({&lt;&gt;})</P><P></P><P></P><P>only({&lt; Date= {"&gt;=$(=(max(Date)))"}&gt;}field)</P></BODY></HTML> Mon, 11 May 2015 18:42:06 GMT https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836234#M1008922 ramoncova06 2015-05-11T18:42:06Z Re: multiple values for a text box https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836235#M1008924 <HTML><HEAD></HEAD><BODY><P>Ramon</P><P></P><P>No, I only have an indicator for current or historical.</P></BODY></HTML> Mon, 11 May 2015 18:44:07 GMT https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836235#M1008924 fcecconi 2015-05-11T18:44:07Z Re: multiple values for a text box https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836236#M1008926 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">ok, then use the current indicator in your set analysis <BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">only({&lt; Date= {&lt;current<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">indicator={'Yes'}</SPAN>&gt;}field)</SPAN></P></BODY></HTML> Mon, 11 May 2015 18:57:33 GMT https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836236#M1008926 ramoncova06 2015-05-11T18:57:33Z Re: multiple values for a text box https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836237#M1008928 <HTML><HEAD></HEAD><BODY><P>here is more details on set analysis <A href="https://community.qlik.com/qlik-blogpost/4076">A Primer on Set Analysis</A></P></BODY></HTML> Mon, 11 May 2015 18:58:35 GMT https://community.qlik.com/t5/QlikView/multiple-values-for-a-text-box/m-p/836237#M1008928 ramoncova06 2015-05-11T18:58:35Z