Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

display largest value in a text object

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

2 Replies
shree909
Partner - Specialist II
Partner - Specialist II

i think can u try MAXSTRING to get the hostname

count(distinct(masxtring(Hostname)))

swuehl
MVP
MVP

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))