Dynamic sort order for a line chart after it is displayed

[#1]

I am trying to allow users of a qlikview document to dynamically change the sort order of a chart.

I have created a variable called vSortOrderValue which is 1 or -1

In the chart I use the Sort expression:

Sum(employeesDaysWorked) * vSortOrderValue

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.

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?

[mike_garcia · Accepted solution]

Try a Dollar-Sign Expansion in the Variable Syntax

=Sum(employeesDaysWorked) * $(vSortOrderValue)

Mike.

[#3]

Can you post that QV file where you have created this?

Probably that will give more clarity for resolving query.