Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert macro of VBS in JScript

Hi, I need help to make a macro that is currently in VBS to JScript.

This macro enables/disables the scrollbar by a button:

sub View_Scroll

   set v=ActiveDocument.Variables("var_Scroll") ' var_Scroll => variable created in the environment qlikview

   if v.GetContent.string="0" then

     v.SetContent "1",false

     value = 1

   else

     v.SetContent "0",false

     value = 0

   end if

  

   dim c(1)

   c(0)="CH01"

   c(1)="CH02"

   for i=0 to 1

     set chart = ActiveDocument.GetSheetObject(c(i))

     set cp = chart.GetProperties

     cp.ChartProperties.XAxisScroll = value

      chart.SetProperties cp

   next  

end sub

Thanks.

2 Replies
Siva_Sankar
Master II
Master II

may i know for what purpose you are trying to conver the code to jscript?

Not applicable
Author

Hi Siva,

We go to migrated to access to documents with Ajax instead IE-Plugin.

I read that this type of macros not work well.

Thx.

Pedro