topic Dynamic sort order for a line chart after it is displayed in QlikView https://community.qlik.com/t5/QlikView/Dynamic-sort-order-for-a-line-chart-after-it-is-displayed/m-p/222538#M75203 <HTML><HEAD></HEAD><BODY><P>I am trying to allow users of a qlikview document to dynamically change the sort order of a chart.</P><P>I have created a variable called vSortOrderValue which is 1 or -1</P><P>In the chart I use the Sort expression:</P><P>Sum(employeesDaysWorked) * vSortOrderValue</P><P>When I bring up the chart the first time it uses the value of vSortOrderValue, I have tried with both 1 and -1 and the chart values are sorted as I would expect.</P><P>But after the chart is display when I change vSortOrderValue from 1 to -1 the sort order never changes. How do I make this work?</P><P></P><P></P></BODY></HTML> Tue, 13 Jul 2010 23:49:14 GMT 2010-07-13T23:49:14Z Dynamic sort order for a line chart after it is displayed https://community.qlik.com/t5/QlikView/Dynamic-sort-order-for-a-line-chart-after-it-is-displayed/m-p/222538#M75203 <HTML><HEAD></HEAD><BODY><P>I am trying to allow users of a qlikview document to dynamically change the sort order of a chart.</P><P>I have created a variable called vSortOrderValue which is 1 or -1</P><P>In the chart I use the Sort expression:</P><P>Sum(employeesDaysWorked) * vSortOrderValue</P><P>When I bring up the chart the first time it uses the value of vSortOrderValue, I have tried with both 1 and -1 and the chart values are sorted as I would expect.</P><P>But after the chart is display when I change vSortOrderValue from 1 to -1 the sort order never changes. How do I make this work?</P><P></P><P></P></BODY></HTML> Tue, 13 Jul 2010 23:49:14 GMT https://community.qlik.com/t5/QlikView/Dynamic-sort-order-for-a-line-chart-after-it-is-displayed/m-p/222538#M75203 2010-07-13T23:49:14Z Dynamic sort order for a line chart after it is displayed https://community.qlik.com/t5/QlikView/Dynamic-sort-order-for-a-line-chart-after-it-is-displayed/m-p/222539#M75204 <HTML><HEAD></HEAD><BODY><P>Try a Dollar-Sign Expansion in the Variable Syntax</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=Sum(employeesDaysWorked) * $(vSortOrderValue)</PRE></BLOCKQUOTE><BR /><BR /> <P>Mike.</P></BODY></HTML> Wed, 14 Jul 2010 04:35:32 GMT https://community.qlik.com/t5/QlikView/Dynamic-sort-order-for-a-line-chart-after-it-is-displayed/m-p/222539#M75204 mike_garcia 2010-07-14T04:35:32Z Dynamic sort order for a line chart after it is displayed https://community.qlik.com/t5/QlikView/Dynamic-sort-order-for-a-line-chart-after-it-is-displayed/m-p/222540#M75205 <HTML><HEAD></HEAD><BODY><P>Can you post that QV file where you have created this?</P><P>Probably that will give more clarity for resolving query.</P></BODY></HTML> Wed, 14 Jul 2010 06:04:20 GMT https://community.qlik.com/t5/QlikView/Dynamic-sort-order-for-a-line-chart-after-it-is-displayed/m-p/222540#M75205 2010-07-14T06:04:20Z