Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Sort by expression in combo chart in Qlik Sense

Can you share some examples to understand the problem better?

utkarshgarg
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.

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?

utkarshgarg
Contributor II

Re: Sort by expression in combo chart in Qlik Sense

Is there a way to do this?

Community Browser