topic Re: Date based on Max Count in QlikView

Date based on Max Count

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to show the date(s) with the largest amount of visitors in a text object.

Example:

Date: Visitor:

01-04-2017 John

01-04-2017 Paul

01-04-2017 Ronald

02-04-2017 Donald

03-04-2017 John

03-04-2017 Paul

So, I expect to see a result 01-04-2017 in my text object. Even more, if multiple days have the largest amount of visitors I want to see all dates.

Thank you in advance

Anil_Babu_Samineni — Mon, 17 Apr 2017 13:14:07 GMT

May be this

FirstSortedValue(Date, -Aggr(Count(Date),Date))

Anonymous — Mon, 17 Apr 2017 13:21:41 GMT

=concat ( IF( aggr ( Rank(count(1)),Date)=1, Date & chr(10)))... You can use any seperator instead of Chr(10)

Mon, 17 Apr 2017 13:49:49 GMT

Thanks, this works!!

Mon, 17 Apr 2017 13:50:35 GMT

Thank you, this works if there is only one busiest day. Thanks you for your time.