https://community.qlik.com/t5/QlikView/Sorting-on-value-expression-when-using-fast-change/m-p/1883288#M1216934 <P>I want my chart sorted on the difference between two years. I know that is (in my case) only possible when the chart is a straight table.&nbsp;</P> <P>Now I want the user give the option to switch between a pivot table and a straight table. When I enable those under General-&gt;Fast type change&nbsp; the option to demote/promote sorting values disappears.</P> <P>Is there another option to achieve my goal. I don't like to have two charts with the same dimensions and expression just to have a different sorting option.</P> <P>&nbsp;</P> <P>Sorting by the Y-value is not possible either because it is not the first expression.</P> Thu, 20 Jan 2022 10:47:38 GMT curiousfellow 2022-01-20T10:47:38Z https://community.qlik.com/t5/QlikView/Sorting-on-value-expression-when-using-fast-change/m-p/1883288#M1216934 <P>I want my chart sorted on the difference between two years. I know that is (in my case) only possible when the chart is a straight table.&nbsp;</P> <P>Now I want the user give the option to switch between a pivot table and a straight table. When I enable those under General-&gt;Fast type change&nbsp; the option to demote/promote sorting values disappears.</P> <P>Is there another option to achieve my goal. I don't like to have two charts with the same dimensions and expression just to have a different sorting option.</P> <P>&nbsp;</P> <P>Sorting by the Y-value is not possible either because it is not the first expression.</P> Thu, 20 Jan 2022 10:47:38 GMT https://community.qlik.com/t5/QlikView/Sorting-on-value-expression-when-using-fast-change/m-p/1883288#M1216934 curiousfellow 2022-01-20T10:47:38Z