display largest value in a text object

[#1]

Hello,

I'm testing to visualize my IIS website log-files with Qlikview. What I am struggling with is to create a text object to display the day with the highest amount of unique client visits.

Below expression I use in a chart with date as my dimension which is limited to output the largest 10 values.

Count(Distinct(Hostname))

How can I now put the largest value in a text object? And how can I create another text object for the amount of unique hosts of today?

Thank you,

Thorsten

[shree909]

i think can u try MAXSTRING to get the hostname

count(distinct(masxtring(Hostname)))

[swuehl]

Try like this

=FirstSortedValue( aggr(Date, Date), aggr( -count(distinct Hostname), Date))

to get the Date, and

=max(aggr( count(distinct Hostname), Date))

to get the max count.

edit:

and for your last request

=count({<Date = {'$(=today())'}>} distinct Hostname)

or

=count(distinct if(Date = today(), Hostname))