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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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]))