topic max and min usage in QlikView

topic max and min usage in QlikView https://community.qlik.com/t5/QlikView/max-and-min-usage/m-p/728300#M261028 <HTML><HEAD></HEAD><BODY><P>Here is my data and trying to find max/min total cpu usage .  total cpu=Cpu-0+cpu-1+cpu-2+cpu-3</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 366px;"><TBODY><TR><TD height="20" width="110">Date</TD><TD class="xl64" width="64">cpu-0</TD><TD class="xl64" width="64">cpu-1</TD><TD class="xl64" width="64">cpu-2</TD><TD class="xl64" width="64">cpu-3</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 1:00</TD><TD align="right" class="xl64">12.20</TD><TD align="right" class="xl64">12.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 3:00</TD><TD align="right" class="xl64">10.30</TD><TD align="right" class="xl64">10.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 5:00</TD><TD align="right" class="xl64">16.60</TD><TD align="right" class="xl64">16.40</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 7:00</TD><TD align="right" class="xl64">23.30</TD><TD align="right" class="xl64">23.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 9:00</TD><TD align="right" class="xl64">24.50</TD><TD align="right" class="xl64">24.50</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 11:00</TD><TD align="right" class="xl64">26.00</TD><TD align="right" class="xl64">25.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 13:00</TD><TD align="right" class="xl64">26.90</TD><TD align="right" class="xl64">26.40</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20"><STRONG style="color: #3366ff;">10/1/2014 15:00</STRONG></TD><TD align="right" class="xl64"><STRONG style="color: #575757;">28.00</STRONG></TD><TD align="right" class="xl64"><SPAN style="color: #575757;"><STRONG>28.10</STRONG></SPAN></TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 17:00</TD><TD align="right" class="xl64">27.20</TD><TD align="right" class="xl64">27.10</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 19:00</TD><TD align="right" class="xl64">25.60</TD><TD align="right" class="xl64">25.50</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 21:00</TD><TD align="right" class="xl64">23.00</TD><TD align="right" class="xl64">23.00</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 23:00</TD><TD align="right" class="xl64">16.30</TD><TD align="right" class="xl64">16.20</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 1:00</TD><TD align="right" class="xl64">10.80</TD><TD align="right" class="xl64">10.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 3:00</TD><TD align="right" class="xl64">9.61</TD><TD align="right" class="xl64">9.16</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 5:00</TD><TD align="right" class="xl64">16.10</TD><TD align="right" class="xl64">15.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 7:00</TD><TD align="right" class="xl64">22.80</TD><TD align="right" class="xl64">22.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 9:00</TD><TD align="right" class="xl64">24.30</TD><TD align="right" class="xl64">24.10</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 11:00</TD><TD align="right" class="xl64">25.70</TD><TD align="right" class="xl64">25.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 13:00</TD><TD align="right" class="xl64">26.20</TD><TD align="right" class="xl64">26.40</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 15:00</TD><TD align="right" class="xl64">27.80</TD><TD align="right" class="xl64">27.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 17:00</TD><TD align="right" class="xl64">27.40</TD><TD align="right" class="xl64">27.40</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 19:00</TD><TD align="right" class="xl64">25.70</TD><TD align="right" class="xl64">26.00</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 21:00</TD><TD align="right" class="xl64">23.10</TD><TD align="right" class="xl64">22.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 23:00</TD><TD align="right" class="xl64">17.00</TD><TD align="right" class="xl64">16.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 1:00</TD><TD align="right" class="xl64">11.00</TD><TD align="right" class="xl64">11.20</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 3:00</TD><TD align="right" class="xl64">9.42</TD><TD align="right" class="xl64">9.33</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 5:00</TD><TD align="right" class="xl64">15.10</TD><TD align="right" class="xl64">14.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 7:00</TD><TD align="right" class="xl64">21.80</TD><TD align="right" class="xl64">21.60</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 9:00</TD><TD align="right" class="xl64">23.50</TD><TD align="right" class="xl64">23.00</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 11:00</TD><TD align="right" class="xl64">24.70</TD><TD align="right" class="xl64">24.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 13:00</TD><TD align="right" class="xl64">25.30</TD><TD align="right" class="xl64">25.10</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 15:00</TD><TD align="right" class="xl64">26.60</TD><TD align="right" class="xl64">26.10</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 17:00</TD><TD align="right" class="xl64">25.90</TD><TD align="right" class="xl64">25.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 19:00</TD><TD align="right" class="xl64">24.60</TD><TD align="right" class="xl64">24.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 21:00</TD><TD align="right" class="xl64">23.00</TD><TD align="right" class="xl64">22.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 23:00</TD><TD align="right" class="xl64">17.50</TD><TD align="right" class="xl64">17.50</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 29 Oct 2014 23:41:08 GMT 2014-10-29T23:41:08Z max and min usage https://community.qlik.com/t5/QlikView/max-and-min-usage/m-p/728300#M261028 <HTML><HEAD></HEAD><BODY><P>Here is my data and trying to find max/min total cpu usage .  total cpu=Cpu-0+cpu-1+cpu-2+cpu-3</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 366px;"><TBODY><TR><TD height="20" width="110">Date</TD><TD class="xl64" width="64">cpu-0</TD><TD class="xl64" width="64">cpu-1</TD><TD class="xl64" width="64">cpu-2</TD><TD class="xl64" width="64">cpu-3</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 1:00</TD><TD align="right" class="xl64">12.20</TD><TD align="right" class="xl64">12.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 3:00</TD><TD align="right" class="xl64">10.30</TD><TD align="right" class="xl64">10.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 5:00</TD><TD align="right" class="xl64">16.60</TD><TD align="right" class="xl64">16.40</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 7:00</TD><TD align="right" class="xl64">23.30</TD><TD align="right" class="xl64">23.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 9:00</TD><TD align="right" class="xl64">24.50</TD><TD align="right" class="xl64">24.50</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 11:00</TD><TD align="right" class="xl64">26.00</TD><TD align="right" class="xl64">25.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 13:00</TD><TD align="right" class="xl64">26.90</TD><TD align="right" class="xl64">26.40</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20"><STRONG style="color: #3366ff;">10/1/2014 15:00</STRONG></TD><TD align="right" class="xl64"><STRONG style="color: #575757;">28.00</STRONG></TD><TD align="right" class="xl64"><SPAN style="color: #575757;"><STRONG>28.10</STRONG></SPAN></TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 17:00</TD><TD align="right" class="xl64">27.20</TD><TD align="right" class="xl64">27.10</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 19:00</TD><TD align="right" class="xl64">25.60</TD><TD align="right" class="xl64">25.50</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 21:00</TD><TD align="right" class="xl64">23.00</TD><TD align="right" class="xl64">23.00</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/1/2014 23:00</TD><TD align="right" class="xl64">16.30</TD><TD align="right" class="xl64">16.20</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 1:00</TD><TD align="right" class="xl64">10.80</TD><TD align="right" class="xl64">10.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 3:00</TD><TD align="right" class="xl64">9.61</TD><TD align="right" class="xl64">9.16</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 5:00</TD><TD align="right" class="xl64">16.10</TD><TD align="right" class="xl64">15.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 7:00</TD><TD align="right" class="xl64">22.80</TD><TD align="right" class="xl64">22.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 9:00</TD><TD align="right" class="xl64">24.30</TD><TD align="right" class="xl64">24.10</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 11:00</TD><TD align="right" class="xl64">25.70</TD><TD align="right" class="xl64">25.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 13:00</TD><TD align="right" class="xl64">26.20</TD><TD align="right" class="xl64">26.40</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 15:00</TD><TD align="right" class="xl64">27.80</TD><TD align="right" class="xl64">27.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 17:00</TD><TD align="right" class="xl64">27.40</TD><TD align="right" class="xl64">27.40</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 19:00</TD><TD align="right" class="xl64">25.70</TD><TD align="right" class="xl64">26.00</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 21:00</TD><TD align="right" class="xl64">23.10</TD><TD align="right" class="xl64">22.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/2/2014 23:00</TD><TD align="right" class="xl64">17.00</TD><TD align="right" class="xl64">16.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 1:00</TD><TD align="right" class="xl64">11.00</TD><TD align="right" class="xl64">11.20</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 3:00</TD><TD align="right" class="xl64">9.42</TD><TD align="right" class="xl64">9.33</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 5:00</TD><TD align="right" class="xl64">15.10</TD><TD align="right" class="xl64">14.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 7:00</TD><TD align="right" class="xl64">21.80</TD><TD align="right" class="xl64">21.60</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 9:00</TD><TD align="right" class="xl64">23.50</TD><TD align="right" class="xl64">23.00</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 11:00</TD><TD align="right" class="xl64">24.70</TD><TD align="right" class="xl64">24.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 13:00</TD><TD align="right" class="xl64">25.30</TD><TD align="right" class="xl64">25.10</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 15:00</TD><TD align="right" class="xl64">26.60</TD><TD align="right" class="xl64">26.10</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 17:00</TD><TD align="right" class="xl64">25.90</TD><TD align="right" class="xl64">25.80</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 19:00</TD><TD align="right" class="xl64">24.60</TD><TD align="right" class="xl64">24.30</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 21:00</TD><TD align="right" class="xl64">23.00</TD><TD align="right" class="xl64">22.90</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR><TR><TD align="right" class="xl63" height="20">10/3/2014 23:00</TD><TD align="right" class="xl64">17.50</TD><TD align="right" class="xl64">17.50</TD><TD align="right" class="xl64">0.00</TD><TD align="right" class="xl64">0.00</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 29 Oct 2014 23:41:08 GMT https://community.qlik.com/t5/QlikView/max-and-min-usage/m-p/728300#M261028 2014-10-29T23:41:08Z Re: max and min usage https://community.qlik.com/t5/QlikView/max-and-min-usage/m-p/728301#M261029 <HTML><HEAD></HEAD><BODY><P>in a textbox?</P><P>=max(aggr(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]),Date))</P><P></P><P>in chart ?</P><P>=rank(rangesum([cpu-0],[cpu-1],[cpu-2],[cpu-3]))</P></BODY></HTML> Wed, 29 Oct 2014 23:55:06 GMT https://community.qlik.com/t5/QlikView/max-and-min-usage/m-p/728301#M261029 maxgro 2014-10-29T23:55:06Z