topic Re: Getting a Ranking Table in QlikView https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775697#M1036821 <HTML><HEAD></HEAD><BODY><P>Is this what you are looking for? PFA</P><P></P><P>Best,</P><P>S</P></BODY></HTML> Mon, 12 Jan 2015 16:50:07 GMT sunny_talwar 2015-01-12T16:50:07Z Getting a Ranking Table https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775693#M1036817 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am having another problem:</P><P>I am comparing power data from different machines. Therefore I want to make a ranking table which should look like this:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Rank</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Machine</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Power Usage</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">Machine C</TD><TD style="padding: 2px;">1100 Ws</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"><P>Machine A</P></TD><TD style="padding: 2px;">905 Ws</TD></TR><TR><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">...</TD><TD style="padding: 2px;">...</TD></TR></TBODY></TABLE><P></P><P>My data contains all machines and their Power Usage over time, so I need to sum it up. But how do I get the rankings?</P><P></P><P></P><P>With kind regards,</P><P></P><P>Alex</P></BODY></HTML> Mon, 12 Jan 2015 16:02:36 GMT https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775693#M1036817 2015-01-12T16:02:36Z Re: Getting a Ranking Table https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775694#M1036818 <HTML><HEAD></HEAD><BODY><P>You will have to use a rank function. Do you have a sample qvw file to work with? I am not exactly sure what are you trying to sum up??</P><P></P><P>Best,</P><P>S</P></BODY></HTML> Mon, 12 Jan 2015 16:13:00 GMT https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775694#M1036818 sunny_talwar 2015-01-12T16:13:00Z Re: Getting a Ranking Table https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775695#M1036819 <HTML><HEAD></HEAD><BODY><P>Use the rank() function, use machine as your dimension, sum of power usage as an expression and then rank(sum(power usage)) as a second expression - sort by this to get in rank order!</P></BODY></HTML> Mon, 12 Jan 2015 16:15:11 GMT https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775695#M1036819 morganaaron 2015-01-12T16:15:11Z Re: Getting a Ranking Table https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775696#M1036820 <HTML><HEAD></HEAD><BODY><P>Thank you for the quick answers.</P><P>I uploaded a sample. Just ask if you need more informations.</P><P></P><P>My data contains a power value for every second. But what i want is a rank table for the complete power usage over time.</P><P>My data:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Machine</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Time</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Power</STRONG></TH></TR><TR><TD style="padding: 2px;">Machine A</TD><TD style="padding: 2px;">0.1</TD><TD style="padding: 2px;">453</TD></TR><TR><TD>Machine A </TD><TD>0.2</TD><TD>460</TD></TR><TR><TD>Machine A</TD><TD>0.3</TD><TD>470</TD></TR><TR><TD>...</TD><TD>...</TD><TD>...</TD></TR></TBODY></TABLE><P></P><P>@ <SPAN class="j-post-author"><STRONG><A href="https://community.qlik.com/people/morganaaron">morganaaron</A> </STRONG></SPAN></P><P><SPAN class="j-post-author"><STRONG><BR /></STRONG></SPAN></P><P><SPAN class="j-post-author">I did as you said and that is almost the solution to my problem. I used a Pivot Table but since "Machines" is the dimension the table columns are "Machines" "rank" "Power". But the sequence of columns i want is "Rank" "Machines" "Power". Can you explain how i do that and how i can sort by rank, please?</SPAN></P></BODY></HTML> Mon, 12 Jan 2015 16:33:37 GMT https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775696#M1036820 2015-01-12T16:33:37Z Re: Getting a Ranking Table https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775697#M1036821 <HTML><HEAD></HEAD><BODY><P>Is this what you are looking for? PFA</P><P></P><P>Best,</P><P>S</P></BODY></HTML> Mon, 12 Jan 2015 16:50:07 GMT https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775697#M1036821 sunny_talwar 2015-01-12T16:50:07Z Re: Getting a Ranking Table https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775698#M1036822 <HTML><HEAD></HEAD><BODY><P>I am actually was not sure what you Power Usage field is within the QlikView application. I am assuming it to be Leistung.</P><P></P><P>Best,</P><P>S</P></BODY></HTML> Mon, 12 Jan 2015 16:52:21 GMT https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775698#M1036822 sunny_talwar 2015-01-12T16:52:21Z Re: Getting a Ranking Table https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775699#M1036823 <HTML><HEAD></HEAD><BODY><P>That is exactly what I needed. Thank you very much!</P></BODY></HTML> Mon, 12 Jan 2015 17:02:04 GMT https://community.qlik.com/t5/QlikView/Getting-a-Ranking-Table/m-p/775699#M1036823 2015-01-12T17:02:04Z