topic Re: I can help you understand the function sort-weight in QlikView

I can help you understand the function sort-weight

Fri, 28 Sep 2012 14:58:20 GMT

table 1

Record ID

1 A

2 B

3 C

4 D

Table 2:

IDRelacion (ID) Field Sort-weight

1 AAA 4

1 BBB 3

1 CCC 2

1 DDD 1

Code in script:

IDRelacion & '' & Country as Field1

I use this expression in a pivot table.:

= ID & chr (10) & Registration & chr (10) & concant (Field1, chr (10), Sort-weight)

I have trouble using the Sort-weigth expression.

Since my data would thus be:

1 A

1 AAA

1 BBB

1 CCC

1 DDD

but I want my Sort-Weight function are as follows:

1 A

1 DDD

1 CCC

1 BBB

1 AAA

I do not understand how to use the Sort-Weigth function to fit me well.

Re: I can help you understand the function sort-weight

swuehl — Fri, 28 Sep 2012 15:02:59 GMT

The Help says:

"Sort-weight should return a numeric value where the lowest value will render the item to be sorted first."

So I think you just need to revert the sort weight distribution.

Re: I can help you understand the function sort-weight

Fri, 28 Sep 2012 15:15:46 GMT

But it would have to create a field in descending order, and where does the sort-weitght, put that field so I put it in that order?

Re: I can help you understand the function sort-weight

swuehl — Fri, 28 Sep 2012 15:20:48 GMT

Sorry, I think I don't fully understand.

There is a sort tab in chart properties where you can e.g. input your weight in sort expression field.

But sorting pivot dimensions might not result in what you want, because 2nd, 3rd, 4th. dimension is not sorted per sub segment.

Re: I can help you understand the function sort-weight

Fri, 28 Sep 2012 15:57:19 GMT

then could not create what I am stating in my comment?

Re: I can help you understand the function sort-weight

swuehl — Fri, 28 Sep 2012 16:06:19 GMT

Sorry, I think I haven't fully got your comment. Could you post a small sample app together with your expected outcome?