topic Re: Most Frequent Intime and OutTime in QlikView https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929723#M321517 <HTML><HEAD></HEAD><BODY><P>In this case, which one you want to show?</P></BODY></HTML> Tue, 01 Dec 2015 11:10:58 GMT Clever_Anjos 2015-12-01T11:10:58Z Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929715#M321509 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find the attached QVW.</P><P></P><P>I have a field with Most Frequent time and Most Frequent Out time.</P><P></P><P>Based on the frequency of <SPAN style="font-size: 13.3333px;">Most Frequent time/<SPAN style="font-size: 13.3333px;">Most Frequent Out time,</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">If <SPAN style="font-size: 13.3333px;">frequency is more then it has to display that.</SPAN></SPAN></P><P></P><P>It is clearly explained in QVW.</P><P></P><P></P><P>Regards,</P><P>Keerthi KS</P></BODY></HTML> Tue, 01 Dec 2015 10:40:11 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929715#M321509 2015-12-01T10:40:11Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929716#M321510 <HTML><HEAD></HEAD><BODY><P>Try =mode(MostFrequentOutTime)</P></BODY></HTML> Tue, 01 Dec 2015 10:43:01 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929716#M321510 Clever_Anjos 2015-12-01T10:43:01Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929717#M321511 <HTML><HEAD></HEAD><BODY><P>Create List Box using below expression</P><P></P><P>=Aggr(IF(Rank(COUNT(MostFrequentOutTime))=1,MostFrequentOutTime),MostFrequentOutTime)</P></BODY></HTML> Tue, 01 Dec 2015 10:43:41 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929717#M321511 MK_QSL 2015-12-01T10:43:41Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929718#M321512 <HTML><HEAD></HEAD><BODY><P>Thanks Clever. I never used that function <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 01 Dec 2015 10:45:33 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929718#M321512 2015-12-01T10:45:33Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929719#M321513 <HTML><HEAD></HEAD><BODY><P>It´s a not very well know function, I remember it because "saved my life" once upon a time <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 01 Dec 2015 10:47:09 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929719#M321513 Clever_Anjos 2015-12-01T10:47:09Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929720#M321514 <HTML><HEAD></HEAD><BODY><P>Thats why we never forget those Function<IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Tue, 01 Dec 2015 10:53:18 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929720#M321514 Anonymous 2015-12-01T10:53:18Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929721#M321515 <HTML><HEAD></HEAD><BODY><P>What if Frequency is equal ? <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">MostFrequentOutTime is same </SPAN></P></BODY></HTML> Tue, 01 Dec 2015 10:57:34 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929721#M321515 2015-12-01T10:57:34Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929722#M321516 <HTML><HEAD></HEAD><BODY><P>When we have the same frequency for 2 or more values, Mode() returns null</P></BODY></HTML> Tue, 01 Dec 2015 11:08:25 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929722#M321516 Clever_Anjos 2015-12-01T11:08:25Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929723#M321517 <HTML><HEAD></HEAD><BODY><P>In this case, which one you want to show?</P></BODY></HTML> Tue, 01 Dec 2015 11:10:58 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929723#M321517 Clever_Anjos 2015-12-01T11:10:58Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929724#M321518 <HTML><HEAD></HEAD><BODY><P>Yea it returns null. What if I need to show atleast one value.</P></BODY></HTML> Tue, 01 Dec 2015 11:13:52 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929724#M321518 2015-12-01T11:13:52Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929725#M321519 <HTML><HEAD></HEAD><BODY><P>But which one? Anyone?</P></BODY></HTML> Tue, 01 Dec 2015 11:15:56 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929725#M321519 Clever_Anjos 2015-12-01T11:15:56Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929726#M321520 <HTML><HEAD></HEAD><BODY><P>The highest one means MostFrequentIntime is more.</P></BODY></HTML> Tue, 01 Dec 2015 11:19:19 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929726#M321520 2015-12-01T11:19:19Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929727#M321521 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>=FirstSortedValue(distinct </P><P>&nbsp; MostFrequentInTime,</P><P>&nbsp; Aggr(-count(MostFrequentInTime),EmpBasicInfoID,MostFrequentInTime )</P><P>)</P></BODY></HTML> Tue, 01 Dec 2015 11:20:10 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929727#M321521 Clever_Anjos 2015-12-01T11:20:10Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929728#M321522 <HTML><HEAD></HEAD><BODY><P>Some Errors in the expression</P></BODY></HTML> Tue, 01 Dec 2015 11:24:40 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929728#M321522 2015-12-01T11:24:40Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929729#M321523 <HTML><HEAD></HEAD><BODY><P>Don´t worry tt shows as errors, but evaluates, maybe a bug <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P><IMG __jive_id="107727" alt="Capturar.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107727_Capturar.PNG" style="height: 123px; width: 620px;" /></P></BODY></HTML> Tue, 01 Dec 2015 11:26:09 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929729#M321523 Clever_Anjos 2015-12-01T11:26:09Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929730#M321524 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Clever. Its working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 01 Dec 2015 11:28:50 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929730#M321524 2015-12-01T11:28:50Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929731#M321525 <HTML><HEAD></HEAD><BODY><P>I think a better solution would be</P><P>=alt(Mode(MostFrequentInTime), // Try mode first, and then FirstSortedValue if Mode() returns null</P><P>FirstSortedValue(distinct </P><P>&nbsp; MostFrequentInTime,</P><P>&nbsp; Aggr(-count(MostFrequentInTime),EmpBasicInfoID,MostFrequentInTime )</P><P>))</P></BODY></HTML> Tue, 01 Dec 2015 11:30:36 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929731#M321525 Clever_Anjos 2015-12-01T11:30:36Z Re: Most Frequent Intime and OutTime https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929732#M321526 <HTML><HEAD></HEAD><BODY><P>When you are using Distinct/NoDistinct with FirstSortedValue, it will show you red lines.. Which is bug !</P></BODY></HTML> Tue, 01 Dec 2015 13:14:04 GMT https://community.qlik.com/t5/QlikView/Most-Frequent-Intime-and-OutTime/m-p/929732#M321526 MK_QSL 2015-12-01T13:14:04Z