topic Re: Rank Straight Table (multiple dimensions) in QlikView

Rank Straight Table (multiple dimensions)

Thu, 19 Nov 2015 11:48:21 GMT

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!

Re: Rank Straight Table (multiple dimensions)

Gysbert_Wassenaar — Thu, 19 Nov 2015 12:24:38 GMT

Can you tell us what you want to rank?

Perhaps you should read these two documents?

Re: Rank Straight Table (multiple dimensions)

Thu, 19 Nov 2015 12:40:38 GMT

"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 €

Re: Rank Straight Table (multiple dimensions)

Gysbert_Wassenaar — Thu, 19 Nov 2015 12:58:53 GMT

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.