topic Re: Different outputs for macro sorting in QlikView

Different outputs for macro sorting

Tue, 05 Apr 2016 14:11:12 GMT

Hello,

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.

Sub SortChart  
  Set ch = ActiveDocument.GetSheetObject("ADHOC")  
  ch.SortBy 4 
   
  Set p = ch.GetProperties  
  Set dims = p.Dimensions  
  
  i = dims.Item(0).SortCriteria.SortByNumeric  
  If i = 1 Then  
  dims.Item(0).SortCriteria.SortByNumeric = -1  
  Else  
  dims.Item(0).SortCriteria.SortByNumeric = 0  
  End If  
  ch.SetProperties p  
End Sub

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 ?

Thank you!

Re: Different outputs for macro sorting

marcus_sommer — Tue, 05 Apr 2016 14:21:50 GMT

The macro itself is running and only the sorting didn't work?

- Marcus

Re: Different outputs for macro sorting

Tue, 05 Apr 2016 14:26:30 GMT

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.

Re: Different outputs for macro sorting

marcus_sommer — Tue, 05 Apr 2016 14:29:44 GMT

With web you mean the IE plugin? Which releases from desktop client, server and plugin do you use?

- Marcus

Re: Different outputs for macro sorting

Tue, 05 Apr 2016 14:39:39 GMT

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.

Re: Different outputs for macro sorting

marcus_sommer — Tue, 05 Apr 2016 14:57:44 GMT

Chrome meant you are using the ajax-client and the most macros won't run in them.

- Marcus

Re: Different outputs for macro sorting

Gysbert_Wassenaar — Tue, 05 Apr 2016 15:12:58 GMT

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.

Re: Different outputs for macro sorting

Wed, 06 Apr 2016 05:58:12 GMT

Is the same thing in Internet Explorer too.

Re: Different outputs for macro sorting

Wed, 06 Apr 2016 05:59:22 GMT

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.

Re: Different outputs for macro sorting

marcus_sommer — Wed, 06 Apr 2016 06:51:39 GMT

If possible you should avoid macros within the gui and there are different alternatives for creating User Controlled Charts In QlikView.

- Marcus

Re: Different outputs for macro sorting

Thu, 07 Apr 2016 12:58:06 GMT

Thank you very much ! I used this method and is working perfect!