topic Showing latest comment with direct discovery in QlikView https://community.qlik.com/t5/QlikView/Showing-latest-comment-with-direct-discovery/m-p/831495#M292599 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have user comments in a sql server table and I am loading them into qlikview with direct discovery. I want to show the latest comment in a straight table, but since I can't use set analysis or qv-functions like only() with DD I am a bit stuck. Is it possible to create this with some trick? I can use max(Comment) to get the first comment in alphabetical order.. not really useful though.</P><P></P><P>I have seen <A href="https://community.qlik.com/docs/DOC-7323">Direct Discovery: Workarounds for Set Analysis (1/3)</A> but I can't use this into my usecase. Can this be solved with some special tricks?</P><P></P><P>//Micke</P></BODY></HTML> Tue, 14 Apr 2015 13:55:49 GMT 2015-04-14T13:55:49Z Showing latest comment with direct discovery https://community.qlik.com/t5/QlikView/Showing-latest-comment-with-direct-discovery/m-p/831495#M292599 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have user comments in a sql server table and I am loading them into qlikview with direct discovery. I want to show the latest comment in a straight table, but since I can't use set analysis or qv-functions like only() with DD I am a bit stuck. Is it possible to create this with some trick? I can use max(Comment) to get the first comment in alphabetical order.. not really useful though.</P><P></P><P>I have seen <A href="https://community.qlik.com/docs/DOC-7323">Direct Discovery: Workarounds for Set Analysis (1/3)</A> but I can't use this into my usecase. Can this be solved with some special tricks?</P><P></P><P>//Micke</P></BODY></HTML> Tue, 14 Apr 2015 13:55:49 GMT https://community.qlik.com/t5/QlikView/Showing-latest-comment-with-direct-discovery/m-p/831495#M292599 2015-04-14T13:55:49Z Re: Showing latest comment with direct discovery https://community.qlik.com/t5/QlikView/Showing-latest-comment-with-direct-discovery/m-p/831496#M292600 <HTML><HEAD></HEAD><BODY><P>Solved this by attaching leading zeros to the comments in the database like this: 00000012|Comment</P><P>Then in expression using =subfield(max(Comment), '|', 2)</P></BODY></HTML> Wed, 15 Apr 2015 14:06:45 GMT https://community.qlik.com/t5/QlikView/Showing-latest-comment-with-direct-discovery/m-p/831496#M292600 2015-04-15T14:06:45Z