Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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))