Sort two dimensions based on total from an expression column within the range of the dimension

Wed, 11 Mar 2015 10:25:06 GMT

Hello,

We have the following situation in a straight table:

3 dimensions ==> BRANDS/GROUPS/Product

1 Expression ==> Sold Incl VAT

We have to define a sort on the dimensions BRANDS and GROUPS, based on the total sum of Sold Incl VAT inside that brand/group (descending order).

Our result should look like this:

Everything from Brand 1 should be first because the total of brand 1 (9.000,-) is higher than the total on brand 2 (8.000,-).

Inside brand 1 everything from group 1 should come first because the total of group 1 (5.000,-) is higher than that of group 2 (4.000,-).

Inside brand 2 everything from group 1 should come first because the total of group 1 insidie brand 2 (5.000,-) is higher than the total of group 2 inside brand 2 (3.000,-).

We tried a few different solutions:

- we started by first disabling all kinds of sorting on the table.

- first we moved the Sold Incl Vat column up in the sort hierarchy (we tried: before BRANDS, before GROUPS, after GROUPS, etc...)

- then we tried to add a sorting on both brands/groups with an expression equal to the expression used in Sold Incl VAT

Nothing seems to be correct. There still seems to be a kind of randomness in the sorting.

What are we doing wrong here? Thx in advance!

BRANDS (D)	GROUPS (D)	Product (D)	Sold Incl VAT (E)
Brand1	Group1	prod1	5000
Brand1	Group2	prod2	4000
Brand2	Group1	prod1	1000
Brand2	Group1	prod1b	1000
Brand2	Group1	prod1c	1000
Brand2	Group1	prod1d	1000
Brand2	Group1	prod1e	1000
Brand2	Group2	prod2	1000
Brand2	Group2	prod2b	1000
Brand2	Group2	prod2c	1000

Re: Sort two dimensions based on total from an expression column within the range of the dimension

Gysbert_Wassenaar — Wed, 11 Mar 2015 10:42:02 GMT

Sort both dimensions by an expression sum([Sold Incl VAT (E)])

topic Re: Sort two dimensions based on total from an expression column within the range of the dimension in QlikView

Sort two dimensions based on total from an expression column within the range of the dimension

Re: Sort two dimensions based on total from an expression column within the range of the dimension