I have a dynamic chart which created based on a macro script. And in that macro I have a sorting method for a specific column.
Set ch = ActiveDocument.GetSheetObject("ADHOC")
Set p = ch.GetProperties
Set dims = p.Dimensions
i = dims.Item(0).SortCriteria.SortByNumeric
If i = 1 Then
dims.Item(0).SortCriteria.SortByNumeric = -1
dims.Item(0).SortCriteria.SortByNumeric = 0
The weird thing is that in the Qlikview Application is sorting well, I have the desired output. Is sorting descending based on desired column.
But when I access the application from the web (linked to a server). Is sorting the chart ascending. I've tried to invert the 'SortChart' macro but nothing.
Do you have any idea why this is happening ?
Yes, the macro is running. The sorting is working well in the qlikview application. But on web is reversed. I want to sort Descending, but on web is sorting Ascending.
The application is on a qlikview server, linked to a domain (website). I'm using a ticketing url in order to link the qv application. And the browser I'm using is Chrome.
Why are you using a macro at all? You could sort by expression for example and use a variable to specify if you want to sort in ascending or descending order. Or use the same dimension twice, once sorted ascending and once sorted descending, and then show/hide one column based again on the value a variable that the users sets with for example a button or text object.
Thank you for the answer. But I'm working on a already developed application, and the chart is dynamical created each time when you press some buttons. And I have to find a workaround.