Rank Straight Table (multiple dimensions)

[#1]

Hi,

I am using a straigh table with 2 dimensions.

The first one is selected using a variable and the second is selected through a cycle group.

For example,

vDim1          cycle group

A                    A

B                    B

C                    C

D                    D

Where you can combine as you wish.

How can I rank and order by the total value combined of the 2 dimensions?

Thanks in advance!

JS

[Gysbert_Wassenaar]

Can you tell us what you want to rank?

Perhaps you should read these two documents?

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[#3]

"How can I rank and order by the total value combined of the 2 dimensions?"

Example:

Dimension A from vDim1                                  Dim B from Cycle Group 

X	a	35 087 328,00 €
X	e	8 754 348,00 €
Y	i	4 906 770,00 €
Z	o	4 882 101,00 €
W	u	4 750 575,00 €
Q	c	4 505 967,00 €

[Gysbert_Wassenaar]

You can calculate the rank with rank(total ...something... ). Sorting can be done by moving the expression to the top of the list on the Sort tab and choosing to sort by Numeric Value in descending order.