topic How can i generate this report? in QlikView https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93790#M15098 <HTML><HEAD></HEAD><BODY><P>Who can help me, if i have this table:</P><P><IMG alt="test1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/206544_test1.png" style="height: 250px; width: 620px;" /></P><P>How to count only last date with red rows and get this result:</P><P><IMG alt="test2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/206549_test2.png" style="height: 144px; width: 620px;" /></P><P>Get and count only last Entry Date base on item.</P></BODY></HTML> Thu, 28 Jun 2018 17:34:04 GMT sadrisalihu 2018-06-28T17:34:04Z How can i generate this report? https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93790#M15098 <HTML><HEAD></HEAD><BODY><P>Who can help me, if i have this table:</P><P><IMG alt="test1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/206544_test1.png" style="height: 250px; width: 620px;" /></P><P>How to count only last date with red rows and get this result:</P><P><IMG alt="test2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/206549_test2.png" style="height: 144px; width: 620px;" /></P><P>Get and count only last Entry Date base on item.</P></BODY></HTML> Thu, 28 Jun 2018 17:34:04 GMT https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93790#M15098 sadrisalihu 2018-06-28T17:34:04Z Re: How can i generate this report? https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93791#M15099 <HTML><HEAD></HEAD><BODY><P>Can you share your excel sample sheet to work on?</P></BODY></HTML> Thu, 28 Jun 2018 18:45:03 GMT https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93791#M15099 vishsaggi 2018-06-28T18:45:03Z Re: How can i generate this report? https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93792#M15100 <HTML><HEAD></HEAD><BODY><P>Hello <STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" data-avatarid="-1" data-userid="98547" data-username="vishsaggi" href="https://community.qlik.com/people/vishsaggi" style="padding: 0 3px 0 0; font-weight: inherit; font-style: inherit; font-size: 1.1em; font-family: inherit; color: #3778c7;">Vishwarath Nagaraju</A></STRONG></P><P>Atteched you have simple data.</P><P>Thanks for you help.</P></BODY></HTML> Thu, 28 Jun 2018 18:57:22 GMT https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93792#M15100 sadrisalihu 2018-06-28T18:57:22Z Re: How can i generate this report? https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93793#M15101 <HTML><HEAD></HEAD><BODY><P>I need to use</P><P>FirstSortedValue() function, but i don't now how to use it.</P></BODY></HTML> Thu, 28 Jun 2018 19:00:04 GMT https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93793#M15101 sadrisalihu 2018-06-28T19:00:04Z Re: How can i generate this report? https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93794#M15102 <HTML><HEAD></HEAD><BODY><P>Will look into this tomorrow.</P></BODY></HTML> Fri, 29 Jun 2018 04:20:02 GMT https://community.qlik.com/t5/QlikView/How-can-i-generate-this-report/m-p/93794#M15102 vishsaggi 2018-06-29T04:20:02Z