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: 
Anonymous
Not applicable

Sort by expression in combo chart in Qlik Sense

I want to sort by expression instead of default options available in the chart. Is there a way to do it?

Whenever I use two measures the sorting stops working and shows random behavior.

4 Replies
Not applicable
Author

Can you share some examples to understand the problem better?

Anonymous
Not applicable
Author

Here you go.. I have attached an example where in I want to sort by sum(Sales Amount). But its not allowing me to do so.

Thanks.

Not applicable
Author

Utkarsh,

You are using above and rowno which are inter record functions and sorting is disabled inter record functions

see here

https://help.qlik.com/sense/en-us/online/Subsystems/WorkingWith/Content/ChartFunctions/InterRecordFu...

Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when chart inter-record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.

and here

When I use the Above() function, doesn't permit to order values. Why?

Anonymous
Not applicable
Author

Is there a way to do this?