topic Re: Macro Parse failed. Functionality was lost error when creating a cyclic group in a Macro in QlikView

Macro Parse failed. Functionality was lost error when creating a cyclic group in a Macro

Tue, 01 Nov 2011 17:30:04 GMT

Hi,

I am receiving an error 'Macro parse failed. Functionality was lost' when a macro is executed to create a cyclic group. This is only happening when using the Access Point. The desktop client works fine. Below is the Macro code. Does anybody know why this may be happening?

sub mSetDatesCyclicGroup

SET x = ActiveDocument.Variables("vDateConditon")

SET y = ActiveDocument.Variables("vMonthEndDisplay")

If x.GetContent.String = "1" Then

If y.GetContent.String = "0" THEN

ActiveDocument.RemoveGroup "Dates"

set gr=ActiveDocument.CreateGroup("Dates")

gr.AddField "MonthEnd"

gr.AddField "WeekEnding"

gr.AddField "Date"

set gp = ActiveDocument.GetGroup("Dates").GetProperties

gp.IsCyclic = true

ActiveDocument.GetGroup("Dates").SetProperties gp

ActiveDocument.GetApplication.Refresh

y.SetContent "1",true

End If

Else

If y.GetContent.String = "1" THEN

ActiveDocument.RemoveGroup "Dates"

set gr=ActiveDocument.CreateGroup("Dates")

gr.AddField "MonthEnd"

set gp = ActiveDocument.GetGroup("Dates").GetProperties

gp.IsCyclic = true

ActiveDocument.GetGroup("Dates").SetProperties gp

ActiveDocument.GetApplication.Refresh

y.SetContent "0",true

End If

end if

end sub

Thanks

Nilesh

Re: Macro Parse failed. Functionality was lost error when creating a cyclic group in a Macro

Thu, 03 Nov 2011 13:34:42 GMT

Hi Nilesh,

Did you try like this

Here you need to check the 3rd option.

Hope it helps you...

Regards...

Re: Macro Parse failed. Functionality was lost error when creating a cyclic group in a Macro

Thu, 03 Nov 2011 13:50:02 GMT

Hi Ravikumar,

I do not get this option to appear. Do you know how I can reset the IE settings for this box to appear?

Thanks

Nilesh

Re: Macro Parse failed. Functionality was lost error when creating a cyclic group in a Macro

Thu, 03 Nov 2011 14:08:11 GMT

Hi Nilesh,

There is no need to change the IE settings.

This window will appear when your file is opened (because it may had macros).It will asks by providing the window for which macros you want to allow.

Please take a look your edit module to be like this.

Regards..

Re: Macro Parse failed. Functionality was lost error when creating a cyclic group in a Macro

Thu, 03 Nov 2011 14:28:33 GMT

This is already set. I am actually trying to execute these macros on a Test Server which now has a Test server license. Are Test servers allowed to execute macros?

Re: Macro Parse failed. Functionality was lost error when creating a cyclic group in a Macro

jcampbell — Tue, 20 Dec 2011 19:47:52 GMT

Yes, a test server can run Macros. The problem is likely that the option to allow any macro to run (as mentioned above) was not selected. To correct this:

1. Open your QVW file via Internet Explorer

2. Type Ctrl + Shift + M

3. Choose the option "Give System Access to Module Script" and click "OK"

Re: Macro Parse failed. Functionality was lost error when creating a cyclic group in a Macro

Thu, 12 Jan 2012 20:24:06 GMT

This has been identified as a bug by Qliktech when we use a macro to create the Cyclic Groups. Not sure when they will target to fix it.

Anonymous — Thu, 09 May 2013 13:14:06 GMT

The only solution I found to my problem was as suggested by Joshua Campbell

Press CTRL + SHIFT +M.

Thanks