topic Re: Sorting straight table by expression in QlikView

Sorting straight table by expression

Tue, 03 Sep 2013 12:48:56 GMT

Hello,

I have a straight table with Names as dimensions, and then i have an expression:

Can i sort the expression by another expression??

Re: Sorting straight table by expression

techvarun — Tue, 03 Sep 2013 12:53:09 GMT

Am not sure i have understood right or wrong.

U mean this ? if yes this thread may help you

Fix the sort order in a straight table

Re: Sorting straight table by expression

Or — Tue, 03 Sep 2013 12:53:35 GMT

From the chart properties, Sort tab, use Sort by: Expression. Keep in mind that your expression has to make sense within the context of the chart, or it may not provide the expected result.

Re: Sorting straight table by expression

Tue, 03 Sep 2013 12:56:56 GMT

i cannot select expression on my expression

Re: Sorting straight table by expression

Tue, 03 Sep 2013 12:58:06 GMT

no. I wanna sort my expression by another expression, but i cannot select expression in sort tab on the expression, only the dimension, and i dont want to sort the dimension

Re: Sorting straight table by expression

Or — Tue, 03 Sep 2013 12:59:41 GMT

You'll have to include a sample QVW - it is not clear what exactly you're doing, I think.

Re: Sorting straight table by expression

Tue, 03 Sep 2013 13:00:05 GMT

this here is the expression i wanna sort:

=concat(DimItemRecommendation.RecommendedConcatItem, chr(10))

i want to sort it by the highest value of a field called Probaility

Re: Sorting straight table by expression

Tue, 03 Sep 2013 13:00:35 GMT

this here is the expression i wanna sort:

=concat(DimItemRecommendation.RecommendedConcatItem, chr(10))

i want to sort it by the highest value of a field called Probaility

Re: Sorting straight table by expression

Tue, 03 Sep 2013 13:01:40 GMT

i want to sort by this: but im not allowed

Re: Sorting straight table by expression

jagan — Tue, 03 Sep 2013 13:01:51 GMT

Hi,

Just double click on the expression column header of the expression and it automatically sorts the table by expression.

Please find attached.

Regards,

Jagan.

Re: Sorting straight table by expression

Or — Tue, 03 Sep 2013 13:04:36 GMT

Thomas,

You cannot sort an expression by another expression. You should sort your *dimension* based on an expression. In your case, follow the instructions mentioned above, but on the Eventtype field.

Re: Sorting straight table by expression

Tue, 03 Sep 2013 13:05:02 GMT

No, cause i dont want it to be sorted by my expression, and want it to be sorted on another expression, which is not included in the table.

But then i should make a new expression and then hide it

Re: Sorting straight table by expression

jagan — Tue, 03 Sep 2013 13:06:43 GMT

Hi,

Give the expression in

Chart Properties -> Sort -> Select Expression and put your expression there. If not working can you attach some sample data.

Regards,

Jagan.

Re: Sorting straight table by expression

Tue, 03 Sep 2013 13:07:21 GMT

thats not what im looking for

Re: Sorting straight table by expression

Tue, 03 Sep 2013 13:08:06 GMT

I still cannot select expression on my expression:

On my sort tab i have:

Dimension: Eventtype

Expression: sum(blabla)

I wanna sort on the expression

Re: Sorting straight table by expression

Or — Tue, 03 Sep 2013 13:09:30 GMT

Then I once again suggest you post a sample QVW.

Sorting an expression based on an expression doesn't make any sense. You can't sort an expression on its own - it has to be tied to dimensions.

Re: Sorting straight table by expression

Tue, 03 Sep 2013 13:10:59 GMT

in my case it does

I cannot post an example sorry:/

Re: Sorting straight table by expression

DavidFoster1 — Tue, 03 Sep 2013 13:20:56 GMT

Hi Thomas

If I understand correctly you have 3 options:

1) You can sort by y-value which refers to the first expression in your chart/table. But this only allows ascending/descending sorting.

2) You select your dimension and then use an expression sort. This is effectively adding another expression to your chart/table. The expression does not have to be related to the dimension directly, it just has to make sense in the table/chart

3) Add the second expression to your chart, sort on it and then hide it (I have not tested this one)

Re: Sorting straight table by expression

Or — Tue, 03 Sep 2013 14:24:22 GMT

I'm still not following.

Dimension - Expression - SortValue

A - 50 - 3

B - 100 - 1

C - 200 - 2

D - 150 - 4

What I would expect you are trying to get is:

B - 100

C - 200

A - 50

D - 150

Your expected result, if I understand your request correctly, is:

A - 100

B - 200

C - 50

D - 150

Is that what you're trying to achieve? Sort the expressions without considering the dimensions they are attached to?

Re: Sorting straight table by expression

Tue, 03 Sep 2013 14:48:43 GMT

Correct!