topic Using set analysis to display max time in QlikView

Using set analysis to display max time

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Using set analysis to display max time

tresB — Wed, 17 May 2017 12:16:26 GMT

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

Re: Using set analysis to display max time

vinieme12 — Wed, 17 May 2017 12:17:00 GMT

as below

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

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

Re: Using set analysis to display max time

Anil_Babu_Samineni — Wed, 17 May 2017 12:17:49 GMT

May be this?

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

Re: Using set analysis to display max time

Wed, 17 May 2017 12:31:56 GMT

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