topic Re: Last value loaded in QlikView https://community.qlik.com/t5/QlikView/Last-value-loaded/m-p/1394628#M423531 <HTML><HEAD></HEAD><BODY><P>This is working what error you get paste this expression in any text object that gives you 845.</P><P></P><P></P><P>=FirstSortedValue(distinct [Tension Ref.],-Date_Time)</P></BODY></HTML> Wed, 04 Oct 2017 16:23:23 GMT its_anandrjs 2017-10-04T16:23:23Z Last value loaded https://community.qlik.com/t5/QlikView/Last-value-loaded/m-p/1394626#M423529 <HTML><HEAD></HEAD><BODY><P>Dear Gurús, </P><P></P><P>I have loaded a table in QlikSense like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date-Time</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Tension Ref.</STRONG></TH></TR><TR><TD style="padding: 2px;">07 Aug 15:55:01</TD><TD style="padding: 2px;">845</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">07 Aug 15:54:03</SPAN></TD><TD style="padding: 2px;">836</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">07 Aug 15:53:05</SPAN></TD><TD style="padding: 2px;">565</TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">...</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">05 Aug 16:04:02</SPAN></TD><TD style="padding: 2px;">546</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">05 Aug <SPAN style="font-size: 13.3333px;">16:03:05</SPAN></SPAN></TD><TD style="padding: 2px;">768</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">05 Aug <SPAN style="font-size: 13.3333px;">16:02:04</SPAN></SPAN></TD><TD style="padding: 2px;">645</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to create a Straight Table in a QlikSense Dashboard with the last "Tension Ref" loaded. I want to obtain the result 845. </P><P></P><P>I have tried several ways but I can't achieve it. Can anyone help me, please?</P><P></P><P>Thanks!!!</P><P></P><P>Regards, </P><P>Jordi</P></BODY></HTML> Wed, 04 Oct 2017 14:52:49 GMT https://community.qlik.com/t5/QlikView/Last-value-loaded/m-p/1394626#M423529 jorditorras 2017-10-04T14:52:49Z Re: Last value loaded https://community.qlik.com/t5/QlikView/Last-value-loaded/m-p/1394627#M423530 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>FirstSortedValue(DISTINCT [</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Tension Ref], -[Date-Time])</STRONG></SPAN></P><P></P><P>Where Date-Time is read as date field by Qlik Sense</P></BODY></HTML> Wed, 04 Oct 2017 15:43:29 GMT https://community.qlik.com/t5/QlikView/Last-value-loaded/m-p/1394627#M423530 sunny_talwar 2017-10-04T15:43:29Z Re: Last value loaded https://community.qlik.com/t5/QlikView/Last-value-loaded/m-p/1394628#M423531 <HTML><HEAD></HEAD><BODY><P>This is working what error you get paste this expression in any text object that gives you 845.</P><P></P><P></P><P>=FirstSortedValue(distinct [Tension Ref.],-Date_Time)</P></BODY></HTML> Wed, 04 Oct 2017 16:23:23 GMT https://community.qlik.com/t5/QlikView/Last-value-loaded/m-p/1394628#M423531 its_anandrjs 2017-10-04T16:23:23Z Re: Last value loaded https://community.qlik.com/t5/QlikView/Last-value-loaded/m-p/1394629#M423532 <HTML><HEAD></HEAD><BODY><P>Yes, I already corrected my answer and marked Sunny's solution as "Correct". </P><P></P><P>Thanks for your message. </P><P></P><P>Regards, </P><P>Jordi</P></BODY></HTML> Wed, 04 Oct 2017 16:26:01 GMT https://community.qlik.com/t5/QlikView/Last-value-loaded/m-p/1394629#M423532 jorditorras 2017-10-04T16:26:01Z