topic display largest value in a text object in QlikView

display largest value in a text object

Thu, 27 Jun 2013 14:12:12 GMT

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

Re: display largest value in a text object

shree909 — Thu, 27 Jun 2013 14:17:52 GMT

i think can u try MAXSTRING to get the hostname

count(distinct(masxtring(Hostname)))

Re: display largest value in a text object

swuehl — Thu, 27 Jun 2013 14:29:58 GMT

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)

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