Getting a Ranking Table

[#1]

Hi

I am having another problem:

I am comparing power data from different machines. Therefore I want to make a ranking table which should look like this:

Rank	Machine	Power Usage
1	Machine C	1100 Ws
2	Machine A	905 Ws
...	...	...

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?

With kind regards,

Alex

[sunny_talwar]

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??

Best,

S

[morganaaron]

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!

[#4]

Thank you for the quick answers.

I uploaded a sample. Just ask if you need more informations.

My data contains a power value for every second. But what i want is a rank table for the complete power usage over time.

My data:

Machine	Time	Power
Machine A	0.1	453
Machine A	0.2	460
Machine A	0.3	470
...	...	...

@ morganaaron

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?

[sunny_talwar · Accepted solution]

Is this what you are looking for? PFA

Best,

S

[sunny_talwar]

I am actually was not sure what you Power Usage field is within the QlikView application. I am assuming it to be Leistung.

Best,

S

[#7]

That is exactly what I needed. Thank you very much!