topic Re: FirstSortedValue multiple dates in QlikView https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131189#M464103 <HTML><HEAD></HEAD><BODY><P>Oops <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P></BODY></HTML> Thu, 12 May 2016 09:51:12 GMT tomhovens 2016-05-12T09:51:12Z FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131177#M464091 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to create a function to calculate the days with the highest occupancy. Till now I have</P><P></P><P>FirstSortedValue(Datum,-Aggr(sum(Occupancy),Contract)). But when there are mutliple dates with the highest occupancy this function doesn't work. How to solve this?</P></BODY></HTML> Thu, 12 May 2016 09:26:11 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131177#M464091 tomhovens 2016-05-12T09:26:11Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131178#M464092 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FirstSortedValue(<STRONG>Distinct</STRONG> Datum,-Aggr(sum(Occupancy),Contract))</SPAN></P></BODY></HTML> Thu, 12 May 2016 09:26:36 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131178#M464092 MK_QSL 2016-05-12T09:26:36Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131179#M464093 <HTML><HEAD></HEAD><BODY><P>Your expression looks good just replace</P><P></P><P><STRONG>Datum</STRONG></P><P></P><P>With</P><P></P><P><STRONG>Distinct Datum</STRONG></P></BODY></HTML> Thu, 12 May 2016 09:28:46 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131179#M464093 trdandamudi 2016-05-12T09:28:46Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131180#M464094 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for the quick answers but.....</P><P><IMG alt="Distinct Datum.png" class="jive-image image-1" src="/legacyfs/online/124409_Distinct Datum.png" style="height: auto;" /></P></BODY></HTML> Thu, 12 May 2016 09:33:31 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131180#M464094 tomhovens 2016-05-12T09:33:31Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131181#M464095 <HTML><HEAD></HEAD><BODY><P>That is just an error shown by the expression editor. Click ok and you should be able to see the result.</P></BODY></HTML> Thu, 12 May 2016 09:35:06 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131181#M464095 sunny_talwar 2016-05-12T09:35:06Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131182#M464096 <HTML><HEAD></HEAD><BODY><P>you are correct, thanks for helping</P></BODY></HTML> Thu, 12 May 2016 09:37:15 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131182#M464096 tomhovens 2016-05-12T09:37:15Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131183#M464097 <HTML><HEAD></HEAD><BODY><P>This is just to scare you, but it works. QlikView sometimes play with us.</P></BODY></HTML> Thu, 12 May 2016 09:38:02 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131183#M464097 Kushal_Chawda 2016-05-12T09:38:02Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131184#M464098 <HTML><HEAD></HEAD><BODY><P>@<STRONG style="color: #3d3d3d; font-family: inherit; line-height: 1.5em; font-style: inherit; font-size: 11.7px;"><A href="https://community.qlik.com/people/tomhovens">tomhovens</A></STRONG></P><P></P><P>Just curious to know.. What's the reason for not selecting my answer as correct !!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Thu, 12 May 2016 09:40:45 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131184#M464098 MK_QSL 2016-05-12T09:40:45Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131185#M464099 <HTML><HEAD></HEAD><BODY><P>Happens to me all the time <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 May 2016 09:41:53 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131185#M464099 sunny_talwar 2016-05-12T09:41:53Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131186#M464100 <HTML><HEAD></HEAD><BODY><P>My answer was 2 mins earlier than selected answer... </P><P>I can understand if the answer was something different than my one.!!!</P><P>It's OK.. We shouldn't try to understand everyone here... Just try our best to help them out...!!</P></BODY></HTML> Thu, 12 May 2016 09:46:22 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131186#M464100 MK_QSL 2016-05-12T09:46:22Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131187#M464101 <HTML><HEAD></HEAD><BODY><P>Neki kar aur dariya mein daal Manish Bhai <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 12 May 2016 09:48:07 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131187#M464101 sunny_talwar 2016-05-12T09:48:07Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131188#M464102 <HTML><HEAD></HEAD><BODY><P>I agree with you and this happens to me also... But it is a satisfaction that we get when we help others in need.</P></BODY></HTML> Thu, 12 May 2016 09:49:33 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131188#M464102 trdandamudi 2016-05-12T09:49:33Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131189#M464103 <HTML><HEAD></HEAD><BODY><P>Oops <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P></BODY></HTML> Thu, 12 May 2016 09:51:12 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131189#M464103 tomhovens 2016-05-12T09:51:12Z Re: FirstSortedValue multiple dates https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131190#M464104 <HTML><HEAD></HEAD><BODY><P>The same happened with <STRONG style="color: #3d3d3d; font-family: inherit; line-height: 1.5em; font-style: inherit; font-size: 11.7px;"><A href="https://community.qlik.com/people/kush141087">kush141087</A></STRONG></P><P></P><P><A href="https://community.qlik.com/thread/216586">Filter multiple values in script</A></P></BODY></HTML> Thu, 12 May 2016 09:53:33 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-multiple-dates/m-p/1131190#M464104 MK_QSL 2016-05-12T09:53:33Z