topic set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/433263#M161470 <HTML><HEAD></HEAD><BODY><P>i have below fields</P><P></P><P><SPAN style="color: #333333;"><STRONG>LogTable:</STRONG></SPAN></P><P>customer.number</P><P>issue.comment</P><P>issue.comment.date</P><P>issue.comment.number</P><P></P><P>NOTE: In the above table customer can have multiple comments on same date. The highest comment.number indicates the latest comments not the date.</P><P></P><P></P><P><SPAN style="color: #333333;"><STRONG>CustomerTable:</STRONG></SPAN></P><P>customer.name</P><P>customer.number</P><P></P><P></P><P>How can i create straight table that shows customer name, last comment date &amp; last comment</P><P></P><P></P><P>In order to do the above. I have to setanalysis like below</P><P></P><P>show issue.comment for the last max issue.comment.number.</P><P></P><P></P><P>customer name&nbsp; | customer number |&nbsp; last issue.comment.date&nbsp; |&nbsp; last.issue.comment (based on max(issue.comment.number)</P></BODY></HTML> Wed, 14 Nov 2012 16:05:22 GMT userid128223 2012-11-14T16:05:22Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/433263#M161470 <HTML><HEAD></HEAD><BODY><P>i have below fields</P><P></P><P><SPAN style="color: #333333;"><STRONG>LogTable:</STRONG></SPAN></P><P>customer.number</P><P>issue.comment</P><P>issue.comment.date</P><P>issue.comment.number</P><P></P><P>NOTE: In the above table customer can have multiple comments on same date. The highest comment.number indicates the latest comments not the date.</P><P></P><P></P><P><SPAN style="color: #333333;"><STRONG>CustomerTable:</STRONG></SPAN></P><P>customer.name</P><P>customer.number</P><P></P><P></P><P>How can i create straight table that shows customer name, last comment date &amp; last comment</P><P></P><P></P><P>In order to do the above. I have to setanalysis like below</P><P></P><P>show issue.comment for the last max issue.comment.number.</P><P></P><P></P><P>customer name&nbsp; | customer number |&nbsp; last issue.comment.date&nbsp; |&nbsp; last.issue.comment (based on max(issue.comment.number)</P></BODY></HTML> Wed, 14 Nov 2012 16:05:22 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/433263#M161470 userid128223 2012-11-14T16:05:22Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/433264#M161471 <HTML><HEAD></HEAD><BODY><P>Look into FirstSortedValue() function:</P><P></P><P>With dimension customer.name, try these expressions:</P><P></P><P>=FirstSortedValue(issue.comment, -issue.comment.number)</P><P>=FirstSortedValue(issue.comment.date, -issue.comment.number)</P><P></P><P>(or just max(issue.comment.date) for the last one)</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Wed, 14 Nov 2012 16:26:44 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/433264#M161471 swuehl 2012-11-14T16:26:44Z