Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

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
Highlighted
Not applicable

Re: Sort by expression in combo chart in Qlik Sense

Can you share some examples to understand the problem better?

Highlighted
Contributor II

Re: Sort by expression in combo chart in Qlik Sense

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.

Highlighted
Not applicable

Re: Sort by expression in combo chart in Qlik Sense

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?

Highlighted
Contributor II

Re: Sort by expression in combo chart in Qlik Sense

Is there a way to do this?