topic all arrival, first, second etc in QlikView https://community.qlik.com/t5/QlikView/all-arrival-first-second-etc/m-p/591602#M219391 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have this request. I have this data sheet:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">order n°</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date</STRONG></TH></TR><TR><TD style="padding: 2px;">00001</TD><TD style="padding: 2px;">d0101</TD><TD style="padding: 2px;">05-02-2014</TD></TR><TR><TD style="padding: 2px;">00002</TD><TD style="padding: 2px;">d0101</TD><TD style="padding: 2px;">25-02-2014</TD></TR><TR><TD style="padding: 2px;">00003</TD><TD style="padding: 2px;">d0101</TD><TD style="padding: 2px;">16-03-2014</TD></TR></TBODY></TABLE><P></P><P>I would have a pivot table as shown</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">product</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">first arrival</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">second arrival</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">third arrival</TH></TR><TR><TD style="padding: 2px;">d0101</TD><TD style="padding: 2px;">05-02-2014</TD><TD style="padding: 2px;">25-02-2014</TD><TD style="padding: 2px;">16-03-2014</TD></TR></TBODY></TABLE><P></P><P>I hope somebody can help me.</P><P></P><P>Many thanks</P><P></P><P>Andrea</P></BODY></HTML> Fri, 31 Jan 2014 08:24:28 GMT andyrebs 2014-01-31T08:24:28Z all arrival, first, second etc https://community.qlik.com/t5/QlikView/all-arrival-first-second-etc/m-p/591602#M219391 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have this request. I have this data sheet:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">order n°</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date</STRONG></TH></TR><TR><TD style="padding: 2px;">00001</TD><TD style="padding: 2px;">d0101</TD><TD style="padding: 2px;">05-02-2014</TD></TR><TR><TD style="padding: 2px;">00002</TD><TD style="padding: 2px;">d0101</TD><TD style="padding: 2px;">25-02-2014</TD></TR><TR><TD style="padding: 2px;">00003</TD><TD style="padding: 2px;">d0101</TD><TD style="padding: 2px;">16-03-2014</TD></TR></TBODY></TABLE><P></P><P>I would have a pivot table as shown</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">product</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">first arrival</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">second arrival</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">third arrival</TH></TR><TR><TD style="padding: 2px;">d0101</TD><TD style="padding: 2px;">05-02-2014</TD><TD style="padding: 2px;">25-02-2014</TD><TD style="padding: 2px;">16-03-2014</TD></TR></TBODY></TABLE><P></P><P>I hope somebody can help me.</P><P></P><P>Many thanks</P><P></P><P>Andrea</P></BODY></HTML> Fri, 31 Jan 2014 08:24:28 GMT https://community.qlik.com/t5/QlikView/all-arrival-first-second-etc/m-p/591602#M219391 andyrebs 2014-01-31T08:24:28Z Re: all arrival, first, second etc https://community.qlik.com/t5/QlikView/all-arrival-first-second-etc/m-p/591603#M219392 <HTML><HEAD></HEAD><BODY><P>Take straight table, dimension product,</P><P></P><P>first expression: Max(date)</P><P>second expression: max(date,2)</P><P>third expression: max(date,3)</P></BODY></HTML> Fri, 31 Jan 2014 08:28:38 GMT https://community.qlik.com/t5/QlikView/all-arrival-first-second-etc/m-p/591603#M219392 tresB 2014-01-31T08:28:38Z