topic Re: Sorting a Legend by Expression in App Development

Sorting a Legend by Expression

YH_IKONS — Wed, 08 Mar 2023 09:52:54 GMT

Good Day

I have a table which correlates the table of ages in its correct order. I have sorted the graph by expression which sorts out the data values correctly as shown below ('Age > 182' is shown as the bottom stack in the bar graph) however, the legend shows this value as second. Is there a way to sort out the legend?

Thank You
Regards
Daanyaal

Re: Sorting a Legend by Expression

BenjaminT — Wed, 08 Mar 2023 16:47:55 GMT

Hi Daanyaal,

Have you tried using the dual() function to assign a numeric sort value to each age bucket alongside the string of text?

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunctions/Dual.htm

Re: Sorting a Legend by Expression

YH_IKONS — Thu, 09 Mar 2023 09:54:39 GMT

Yes, I have a table with two collumns. One column has the age buckets and the other has its required order (1, 2, 3 and so on called "Age sequence"). I have sorted the age buckets according to the Age sequence which has ordered the stacks of the bar chart correctly however the legend is still being sorted incorrectly.