topic Re: utilisation of firstsortedvalue in QlikView https://community.qlik.com/t5/QlikView/utilisation-of-firstsortedvalue/m-p/416574#M487295 <HTML><HEAD></HEAD><BODY><P>Create a chart with dimension CUSTOMER and as expression</P><P></P><P>=FirstSortedValue(PRODUCT, [BUYING DATE])</P><P></P><P>take care that buying date field has a numeric representation (i.e. is interpreted as date by QV).</P></BODY></HTML> Thu, 07 Feb 2013 17:40:33 GMT swuehl 2013-02-07T17:40:33Z utilisation of firstsortedvalue https://community.qlik.com/t5/QlikView/utilisation-of-firstsortedvalue/m-p/416573#M487294 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm new to qlikview and i'm having trouble using firstsortedvalue.</P><P>This is what i'm working on:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>CUSTOMER</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>BUYING DATE</STRONG></SPAN></TH></TR><TR><TD>CUSTOMER 1</TD><TD>PRODUCT 1</TD><TD>22/11/2009</TD></TR><TR><TD>CUSTOMER <A></A><A></A><A></A><A></A><A></A><A></A>1</TD><TD>PRODUCT 2</TD><TD>24/05/2012</TD></TR><TR><TD>CUSTOMER 1</TD><TD>PRODUCT 3</TD><TD>12/02/2010</TD></TR><TR><TD>CUSTOMER <A></A><A></A><A></A><A></A><A></A><A></A>2</TD><TD>PRODUCT 1</TD><TD>13/07/2007</TD></TR><TR><TD>CUSTOMER 3 </TD><TD>PRODUCT 1</TD><TD>30/04/2002</TD></TR><TR><TD>CUSTOMER <A></A><A></A><A></A><A></A><A></A><A></A><A></A><A></A><A></A><A></A>3</TD><TD>PRODUCT 2</TD><TD>01/04/2000</TD></TR><TR><TD>CUSTOMER <A></A><A></A><A></A><A></A><A></A><A></A><A></A><A></A><A></A><A></A><A></A><A></A>3</TD><TD>PRODUCT 3</TD><TD>08/08/2008</TD></TR></TBODY></TABLE><P></P><P> i would like to know the product that each customer bought in the first place.</P><P>So what i would like to see is:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>CUSTOMER</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PRODUCT</STRONG></SPAN></TH></TR><TR><TD>CUSTOMER 1</TD><TD>PRODUCT 1</TD></TR><TR><TD>CUSTOMER 2</TD><TD>PRODUCT 1</TD></TR><TR><TD>COSTOMER 3</TD><TD>PRODUCT 2</TD></TR></TBODY></TABLE><P></P><P>How should i do this?</P><P></P><P>Thanks a lot!</P></BODY></HTML> Thu, 07 Feb 2013 17:36:08 GMT https://community.qlik.com/t5/QlikView/utilisation-of-firstsortedvalue/m-p/416573#M487294 2013-02-07T17:36:08Z Re: utilisation of firstsortedvalue https://community.qlik.com/t5/QlikView/utilisation-of-firstsortedvalue/m-p/416574#M487295 <HTML><HEAD></HEAD><BODY><P>Create a chart with dimension CUSTOMER and as expression</P><P></P><P>=FirstSortedValue(PRODUCT, [BUYING DATE])</P><P></P><P>take care that buying date field has a numeric representation (i.e. is interpreted as date by QV).</P></BODY></HTML> Thu, 07 Feb 2013 17:40:33 GMT https://community.qlik.com/t5/QlikView/utilisation-of-firstsortedvalue/m-p/416574#M487295 swuehl 2013-02-07T17:40:33Z