topic FirstSorted, find last value before (or equal to) 08:00 in QlikView https://community.qlik.com/t5/QlikView/FirstSorted-find-last-value-before-or-equal-to-08-00/m-p/965904#M331091 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>need to show the last value before 08:00 but something is wrong.</P><P>The very last value is picked instead.</P><P></P><P>Pls see below and attached example files.</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/100466_Capture.JPG" style="width: 620px; height: 543px;" /></P></BODY></HTML> Wed, 30 Sep 2015 08:57:23 GMT 2015-09-30T08:57:23Z FirstSorted, find last value before (or equal to) 08:00 https://community.qlik.com/t5/QlikView/FirstSorted-find-last-value-before-or-equal-to-08-00/m-p/965904#M331091 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>need to show the last value before 08:00 but something is wrong.</P><P>The very last value is picked instead.</P><P></P><P>Pls see below and attached example files.</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/100466_Capture.JPG" style="width: 620px; height: 543px;" /></P></BODY></HTML> Wed, 30 Sep 2015 08:57:23 GMT https://community.qlik.com/t5/QlikView/FirstSorted-find-last-value-before-or-equal-to-08-00/m-p/965904#M331091 2015-09-30T08:57:23Z