Most Frequent Intime and OutTime

[#1]

Hi,

Please find the attached QVW.

I have a field with Most Frequent time and Most Frequent Out time.

Based on the frequency of Most Frequent time/Most Frequent Out time,

If frequency is more then it has to display that.

It is clearly explained in QVW.

Regards,

Keerthi KS

[Clever_Anjos]

But which one? Anyone?

[#3]

The highest one means MostFrequentIntime is more.

[Clever_Anjos]

Try this:

=FirstSortedValue(distinct

  MostFrequentInTime,

  Aggr(-count(MostFrequentInTime),EmpBasicInfoID,MostFrequentInTime )

)

[#5]

Some Errors in the expression

[Clever_Anjos]

Don´t worry tt shows as errors, but evaluates, maybe a bug

[#7]

Thanks a lot Clever. Its working

[Clever_Anjos]

I think a better solution would be

=alt(Mode(MostFrequentInTime), // Try mode first, and then FirstSortedValue if Mode() returns null

FirstSortedValue(distinct

  MostFrequentInTime,

  Aggr(-count(MostFrequentInTime),EmpBasicInfoID,MostFrequentInTime )

))

[MK_QSL]

When you are using Distinct/NoDistinct with FirstSortedValue, it will show you red lines.. Which is bug !