How to order a graphe dimension by an expression ?

[#1]

Hello,

I try to order a dimension in a graph by expression .

but it's seem not work.

Someone can give me information about how to do this ?

My table is :

Period / Dimension1 / Type / Type_order / value

in my graph, i have only one dimension Type (i want order it by type_order)

I have only one expression (= sum(value) )

Thanks

[#2]

Hi,

In the chart properties there is a 'Sort' tab. Select the checkbox 'Expression' and enter the field by which you want to sort the dimension. You can also select asceding or descending order there.

Thanks

Amit

[#3]

My version is 8.5. => it's seem it did not work

Qlikview show something in asc order but if i put desc order : the order don't change

strange ?

[Oleg_Troyansky]

A few things to consider:

1. make sure you have an equal sign "=" in the beginning of your sort expression

2. You might have to use function only(typeorder) to sort by expression

3. If it still doesn't work - please post an example here.

Oleg

[#5]

A few things to keep in mind:

1. Sort by Expression is not available for calculated dimensions.

2. There is no syntax check ("Expression OK", color coding, etc.) in the Sort by Expression editor. If you have an invalid expression, it will simply be ignored - similar to your description. I would suggest copying the expression to a text object to check it (field names, syntax, etc.)

Phil