Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 ?
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
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