topic Aggregate Expression Help in QlikView

Aggregate Expression Help

Thu, 08 Jul 2010 15:31:09 GMT

Hey All. I'm a beginner user trying to get a grip on expressions. I'm pretty sure what I need to accomplish is pretty simple but I'm definitely struggling. Any guides on expressions would also be appreciated.

I need a label to aggregate the max number of users at any time, summed across all values. I.e. In the example below, if Jun 5 was selected it would return 11. If June 6 was selected it would return 10. If nothing was selected it return 11. If Serv1 was selected, it would return 5. If Serv1 and June 6 were selected it would return 3, etc.

DateTime	Server	Max Users
Jun 5	Serv1	5
Jun 5	Serv2	6
Jun 6	Serv1	3
Jun 6	Serv2	7

Thanks in advance for any guidance that can be provided.

Aggregate Expression Help

Thu, 08 Jul 2010 15:43:36 GMT

Ah. Should've kept at it before posting.

Got the expression:

=sum(aggr(max([Max Users]),Server))

A useful page in the F1 help menu was 'Expression syntax for calculated formulas'

Aggregate Expression Help

Thu, 08 Jul 2010 15:57:38 GMT

Something like this:

='Max User = ' &
if(len(GetFieldSelections('DateTime')) and len(GetFieldSelections('Server')),
max(aggr(sum([Max Users]), DateTime, Server)),
if (len(GetFieldSelections('Server')) = 0, max(aggr(sum([Max Users]), DateTime)),
max(aggr(sum([Max Users]), Server))))

See attachment.