topic Re: I need to get only the first value in the list in QlikView https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571531#M212939 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this expression,</P><P>=FieldValue('Dimension/Field Name',1)</P><P>Hope this will help you...</P><P>Regards,</P><P>Vijeta</P></BODY></HTML> Tue, 29 Apr 2014 04:24:22 GMT vijetas42 2014-04-29T04:24:22Z I need to get only the first value in the list https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571528#M212936 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="en"><SPAN class="hps">Hello:</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">I need to get</SPAN> <SPAN class="hps">only the first</SPAN> <SPAN class="hps">value in the list:</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"></SPAN></SPAN> </P><P><SPAN class="short_text" lang="en"><SPAN class="hps">Examplo:</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><IMG alt="pantalla.bmp" class="jive-image" src="https://community.qlik.com/legacyfs/online/58070_pantalla.bmp" style="width: 620px; height: 164px;" /></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps">I have a</SPAN> <SPAN class="hps">set of records</SPAN> <SPAN class="hps">which are repeated, <SPAN class="short_text" lang="en"><SPAN class="hps">I need to get</SPAN> <SPAN class="hps">only the first</SPAN> <SPAN class="hps">value in the list:</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>If<SPAN style="font-size: 8pt;">(</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">escoger2</EM></STRONG></EM></STRONG><SPAN style="font-size: 8pt;"> ='Emp. Que No Se Le Pagaron Vacaciones',</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN>FirstSortedValue</P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">HisPagAnoPro</SPAN><SPAN style="font-size: 8pt;"> = '2014' </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">ProNomCod</SPAN><SPAN style="font-size: 8pt;"> = 1 </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">HisPagFlgRev</SPAN><SPAN style="font-size: 8pt;"> &lt;&gt;'R', </SPAN><SPAN style="color: #800000; font-size: 8pt;">EmpCod</SPAN><SPAN style="font-size: 8pt;">), </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Helpme</SPAN></P><P><SPAN style="font-size: 8pt;">Please</SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN class="hps"></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN> </P></BODY></HTML> Tue, 29 Apr 2014 00:29:01 GMT https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571528#M212936 2014-04-29T00:29:01Z Re: I need to get only the first value in the list https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571529#M212937 <HTML><HEAD></HEAD><BODY><P>FirstSortedValue expects two parameters,</P><P>1) The expression to be sorted</P><P>2) The rank order</P><P></P><P>Maybe</P><P>FirstSortedValue(<SPAN style="color: #800000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 11px;">EmpCod</SPAN>,[Some Sorting Expression]) can calculate what you want</P></BODY></HTML> Tue, 29 Apr 2014 01:00:43 GMT https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571529#M212937 Clever_Anjos 2014-04-29T01:00:43Z Re: I need to get only the first value in the list https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571530#M212938 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you attach some sample, or try the following functions</P><P></P><P>=MaxString(DimensionName)</P><P>=MinString(DimensionName)</P><P>=FieldValue(DimensionName, N)</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Tue, 29 Apr 2014 04:04:05 GMT https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571530#M212938 jagan 2014-04-29T04:04:05Z Re: I need to get only the first value in the list https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571531#M212939 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this expression,</P><P>=FieldValue('Dimension/Field Name',1)</P><P>Hope this will help you...</P><P>Regards,</P><P>Vijeta</P></BODY></HTML> Tue, 29 Apr 2014 04:24:22 GMT https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571531#M212939 vijetas42 2014-04-29T04:24:22Z Re: I need to get only the first value in the list https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571532#M212940 <HTML><HEAD></HEAD><BODY><P>i think it can be possible in by first sorted value </P></BODY></HTML> Tue, 29 Apr 2014 04:41:36 GMT https://community.qlik.com/t5/QlikView/I-need-to-get-only-the-first-value-in-the-list/m-p/571532#M212940 2014-04-29T04:41:36Z