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

Using set analysis to display max time

Hi,

I want to display the Max created time by team in a text box

Team Name        Created Time        

Team A                 09:00                  

Team B                 09:00                   

Team C                 09:00                   

Team A                 10:00                   

Team B                10:00                   

So for Team A I would want to display 10:00. I've tried the below Set Analysis but it's obviously incorrect

=max({$<[Team Name]={$(=Team A)}>}[[Time created])

This is already working in a pivot table using this expression - =sum([Time created]*if([Time created]=aggr(nodistinct max([Time created]), [Team Name]),1,0))

I just want to replicate in a text box for a individual team.

Thanks in advance

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be this?

=Time(Max({<[Team Name] = {'Team A'}>}[Created Time]),'hh:mm')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies
tresesco
MVP
MVP

Try like:

=max({$<[Team Name]={'Team A'}>}[[Time created])


Single quotes around the field value. Note: You might have to format your output using time() around max().

vinieme12
Champion III
Champion III

as below

Team A =max({$<[Team Name]={'Team A'}>}[[Time created])

Team B =max({$<[Team Name]={'Team B'}>}[[Time created])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anil_Babu_Samineni

May be this?

=Time(Max({<[Team Name] = {'Team A'}>}[Created Time]),'hh:mm')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

Thanks very much for all your replies. That has worked perfectly.