Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to order a graphe dimension by an expression ?

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

4 Replies
Not applicable
Author

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

Not applicable
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

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