Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

max and min usage

Here is my data and trying to find max/min total cpu usage .  total cpu=Cpu-0+cpu-1+cpu-2+cpu-3

Datecpu-0cpu-1cpu-2cpu-3
10/1/2014 1:0012.2012.300.000.00
10/1/2014 3:0010.3010.300.000.00
10/1/2014 5:0016.6016.400.000.00
10/1/2014 7:0023.3023.300.000.00
10/1/2014 9:0024.5024.500.000.00
10/1/2014 11:0026.0025.900.000.00
10/1/2014 13:0026.9026.400.000.00
10/1/2014 15:0028.0028.100.000.00
10/1/2014 17:0027.2027.100.000.00
10/1/2014 19:0025.6025.500.000.00
10/1/2014 21:0023.0023.000.000.00
10/1/2014 23:0016.3016.200.000.00
10/2/2014 1:0010.8010.800.000.00
10/2/2014 3:009.619.160.000.00
10/2/2014 5:0016.1015.900.000.00
10/2/2014 7:0022.8022.800.000.00
10/2/2014 9:0024.3024.100.000.00
10/2/2014 11:0025.7025.900.000.00
10/2/2014 13:0026.2026.400.000.00
10/2/2014 15:0027.8027.800.000.00
10/2/2014 17:0027.4027.400.000.00
10/2/2014 19:0025.7026.000.000.00
10/2/2014 21:0023.1022.900.000.00
10/2/2014 23:0017.0016.900.000.00
10/3/2014 1:0011.0011.200.000.00
10/3/2014 3:009.429.330.000.00
10/3/2014 5:0015.1014.800.000.00
10/3/2014 7:0021.8021.600.000.00
10/3/2014 9:0023.5023.000.000.00
10/3/2014 11:0024.7024.300.000.00
10/3/2014 13:0025.3025.100.000.00
10/3/2014 15:0026.6026.100.000.00
10/3/2014 17:0025.9025.800.000.00
10/3/2014 19:0024.6024.300.000.00
10/3/2014 21:0023.0022.900.000.00
10/3/2014 23:0017.5017.500.000.00
1 Solution

Accepted Solutions
maxgro
MVP
MVP

in a textbox?

=max(aggr(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]),Date))

in chart ?

=rank(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]))

View solution in original post

1 Reply
maxgro
MVP
MVP

in a textbox?

=max(aggr(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]),Date))

in chart ?

=rank(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]))