Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
i think can u try MAXSTRING to get the hostname
count(distinct(masxtring(Hostname)))
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))