topic Macro parse failed in QlikView

Macro parse failed

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I'm trying to implement a dynamic cyclic group. Therefore I have created a little macro which should do the trick. Problem is that the macro is running in QlikView client without any issues but not using a browser.

The macro code is kind of simple like this:

Sub DynamicGroup ActiveDocument.GetApplication.WaitForIdle ActiveDocument.RemoveGroup "CyclicGroup1" Set gr = ActiveDocument.CreateGroup("CyclicGroup1") gr.AddField "Field1" gr.AddField "Field2" dim x(2) set gp = ActiveDocument.GetGroup("CyclicGroup1").GetProperties x(1) = "FIELD1" x(2) = "FIELD2" gp.Labels = x gp.IsCyclic = true ActiveDocument.GetGroup("CyclicGroup1").SetProperties gp ActiveDocument.GetApplication.Refresh End Sub

When I run this macro in the client there is no problem but when I run it in the browser then I get the error message:

Macro parse failed. Functionality was lost DynamicGroup Error: Object needed 'gr'

I'm running QlikView 9 SR7.

Can anyone help me with this?

Regards

Macro parse failed

deepakk — Tue, 22 Mar 2011 14:51:07 GMT

hi,

I am not sure, but i dont think you can create cyclic group in IE.

I have once tried to create cyclic grp(not by macro) through chart properties but the edit group button was disabled.

AW:Re: Macro parse failed

Tue, 22 Mar 2011 14:56:46 GMT

If it wouldn#t be possible I'm wondering why it should be possible to remove a cyclic group because the first line of the macro removes the group before it is recreated.

And the group is definitely not usable after the macro has been executed so I guess it must be something other.

But that is just a conclusion from my point of view. Does anyone know a possibility to get an "official" answer to this?

Regards

AW:Re: Macro parse failed

Miguel_Angel_Baeyens — Tue, 22 Mar 2011 15:02:43 GMT

Hi,

Are both client and server running same version of QlikView?

Regards.

AW:Re: Macro parse failed

Tue, 22 Mar 2011 15:07:08 GMT

hi im getting the same Macro Parse Failed message. I set up a post and still awaiting help.

http://community.qlik.com/forums/t/42978.aspx

Good luck.

AW:Re: AW:Re: Macro parse failed

Tue, 22 Mar 2011 15:16:50 GMT

HI,

just to make sure I have just reinstalled the QlikView plugin on my machine and I'm still getting the error.

Any further idea?

Reagrds

AW:Re: AW:Re: Macro parse failed

Miguel_Angel_Baeyens — Tue, 22 Mar 2011 15:25:03 GMT

You're right.

Let's see what other users say, but it seems to me a bug here to be reported to QlikTech support.

AW:Re: AW:Re: AW:Re: Macro parse failed

Tue, 22 Mar 2011 15:26:40 GMT


Miguel Angel Baeyens wrote:
You're right.

Does this mean you can reproduce the error at your site and think that it should be possible to create a cyclic using a macro through the plugin?

Regards

AW:Re: AW:Re: AW:Re: Macro parse failed

Miguel_Angel_Baeyens — Tue, 22 Mar 2011 15:55:55 GMT

Hello,

If the macro doesn't work, it should be triggered by pressing the button (similar to what happens when your macro saves the document, for example).

But in this case (I'm using 10 SR1) the macro triggers and starts working, but it stops in this place, (because of creating fields permissions? don't think so, using section access works as expected as well).

EDIT: The group is actually removed, then created, but fields are not added to that group, even using one dimension.

AW:Re: AW:Re: AW:Re: Macro parse failed

Tue, 22 Mar 2011 16:06:09 GMT

Hi Miguel,

Heres my macro script:

----------------------------------------------------------------------------------------------------------

Sub SubmitQuestionnaire

Set oXL=CreateObject("Excel.Application")

'set doc = ActiveDocument
'set mySelection = doc.fields("User").GetSelectedValues
'for i = 0 to mySelection.Count -1
'strIndex = mySelection.Item(i).text
'next

strIndex = ActiveDocument.Variables("Username").GetContent.String

set DATA1 = ActiveDocument.GetApplication.GetProperties
VarHolder1 = now()
set temp = ActiveDocument.GetApplication.GetProperties
VarHolder2 = mid(temp.UserName,4)
set vCommentsToExcel = ActiveDocument.Variables("vUserEmail")
VarHolder3 = vCommentsToExcel.GetContent.String
set vCommentsToExcel = ActiveDocument.Variables("vUserPhone")
VarHolder4 = vCommentsToExcel.GetContent.String
set vCommentsToExcel = ActiveDocument.Variables("Quest1Answer")
VarHolder5 = vCommentsToExcel.GetContent.String
set vCommentsToExcel = ActiveDocument.Variables("Quest2Answer")
VarHolder6 = vCommentsToExcel.GetContent.String
set vCommentsToExcel = ActiveDocument.Variables("Quest3Answer")
VarHolder7 = vCommentsToExcel.GetContent.String
set vCommentsToExcel = ActiveDocument.Variables("vOtherFeedback")
VarHolder8 = vCommentsToExcel.GetContent.String

f_name = "\\Nmh-bus01\QVDataSource\QlikView Questionnaires\Question Answers.xls"
set oWB = oXL.Workbooks.Open(f_name)
set oSH = oWB.Worksheets.Item(1)

With oWB.Worksheets.Item(1).Range("a1:a1000")
Set c = .Find(strIndex, , , 2, 1, 2, 0)
If Not c Is Nothing Then
firstAddress = c.Address
Do
VarHolder = VarHolder + 1
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With

if VarHolder = 100 then
msgbox("It appears you have already submitted a questionnaire. To resubmit please delete old questionnaire?")
oWB.Close

set oSH = Nothing
set oWB = nothing
set oXL = nothing

'CLEAR SELECTIONS IF QUESTIONNAIRE ALREADY SUBMITTED
set v = ActiveDocument.Variables("vUserEmail")
v.SetContent "",true
set v = ActiveDocument.Variables("vUserPhone")
v.SetContent "",true
set v = ActiveDocument.Variables("Quest1Answer")
v.SetContent "",true
set v = ActiveDocument.Variables("Quest2Answer")
v.SetContent "",true
set v = ActiveDocument.Variables("Quest3Answer")
v.SetContent "",true
set v = ActiveDocument.Variables("vOtherFeedback")
v.SetContent "",true
exit sub
else

'PASTE THE VALUES INTO EXCEL SHEET SPECIFIED
'username index
oSH.Range("A65536").End(-4162).Offset(1,0).FormulaR1C1 = strIndex
'date submitted
oSH.Range("A65536").End(-4162).Offset(0,1).FormulaR1C1 = VarHolder1
'user login
oSH.Range("A65536").End(-4162).Offset(0,2).FormulaR1C1 = VarHolder2
'optional user contact details
oSH.Range("A65536").End(-4162).Offset(0,3).FormulaR1C1 = VarHolder3
oSH.Range("A65536").End(-4162).Offset(0,4).FormulaR1C1 = VarHolder4
'question answers 1-3
oSH.Range("A65536").End(-4162).Offset(0,5).FormulaR1C1 = VarHolder5
oSH.Range("A65536").End(-4162).Offset(0,6).FormulaR1C1 = VarHolder6
oSH.Range("A65536").End(-4162).Offset(0,7).FormulaR1C1 = VarHolder7
'additional feedback
oSH.Range("A65536").End(-4162).Offset(0,8).FormulaR1C1 = VarHolder8

If f_name="False" then

Set oXL=nothing
Exit sub
End If

oWB.Save
oWB.Close

Set oSH=nothing
Set oWB=nothing
Set oXL=nothing

'CLEAR SELECTIONS AFTER SUBMISSION
set v = ActiveDocument.Variables("vUserEmail")
v.SetContent "",true
set v = ActiveDocument.Variables("vUserPhone")
v.SetContent "",true
set v = ActiveDocument.Variables("Quest1Answer")
v.SetContent "",true
set v = ActiveDocument.Variables("Quest2Answer")
v.SetContent "",true
set v = ActiveDocument.Variables("Quest3Answer")
v.SetContent "",true
set v = ActiveDocument.Variables("vOtherFeedback")
v.SetContent "",true

msgbox("Thank you for completing the 'March 2011 - QlikView Questionnaire. Your answers will be reflected in the next report refresh.")
'ActiveDocument.Reload
ActiveDocument.ClearAll
'ActiveDocument.CloseDoc
'App.OpenDoc "http://nmh-vapps03/QvAJAXZfc/AccessPoint.aspx?open=&id=QVS@nmh-vapps03%7CCorporate/User%20Guidance/Orientation%20page.qvw&client=Plugin"

end if
End Sub

-------------------------------------------------------------------------------

As you can see there are many 'set' attributes in the script if i remove these it wont work.

Is this a QlikView 9 bug?

AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Tue, 22 Mar 2011 20:22:25 GMT


Miguel Angel Baeyens wrote:
EDIT: The group is actually removed, then created, but fields are not added to that group, even using one dimension. <div></div>

I found the same but I have just made another finding. The macro is not even working when the QlikView document is opened with the full client but not opened directly instead using the function "open on server".

Is it possible that this kind of macro is not meant to be working when opening the document as a "normal" user on the server?

And if yes is there another possibility to create dynamic cyclic without using macros?

Regards

AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Miguel_Angel_Baeyens — Tue, 22 Mar 2011 21:10:03 GMT

I'm using version 10 by the way, so even if it's not a bug, it's worth a note to the Support guys.

Anyway, my guess is that, what a group is at the end is one field. I doesn't make any sense if you cannot access to the script or macro editor, but you can create a field/dimension. I'll give a couple of additional tests just in case.

Regards.

AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Tue, 22 Mar 2011 21:17:08 GMT


Miguel Angel Baeyens wrote:
Anyway, my guess is that, what a group is at the end is one field. I doesn't make any sense if you cannot access to the script or macro editor, but you can create a field/dimension. I'll give a couple of additional tests just in case. <div></div>

I agree with that but the sense of the macro is that cyclic group gets a dynamic which is from my knowledge only possible with the use of a macro.

Therefore I would say that it should be working because otherwise there would be no possibility.

Looking forward to the results of your tests.

Regards

EDIT: Just an additional note. If a "normal" user should not access the fields through the macro then the macro should not be executed in any way. Because right now the group is deleted an recreated but the rest is not working. So this is the worst constellation.

AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Miguel_Angel_Baeyens — Tue, 22 Mar 2011 21:22:57 GMT


AndreBer wrote:EDIT: Just an additional note. If a "normal" user should not access the fields through the macro then the macro should not be executed in any way. Because right now the group is deleted an recreated but the rest is not working. So this is the worst constellation.

Agree. If the macro removes the group and creates it, it should work or not, but completely. Let the rest of coders here and VB gurus take a look at our code and see what they say.

AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Wed, 23 Mar 2011 16:27:56 GMT

Hi,

we have the same problem with the ActiveDocument.CreateGroup command when it's executed within a macro on a server. Did you already asked the QlikView support?

Thomas

AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Wed, 23 Mar 2011 16:29:41 GMT

Hi i havent asked aupport as i was hoping this would help me resolve it ASAP.

AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Wed, 23 Mar 2011 16:31:36 GMT


thomas.peter wrote:
we have the same problem with the ActiveDocument.CreateGroup command when it's executed within a macro on a server. Did you already asked the QlikView support?<div></div>

We forwarded this issue to the company from which we bought QlikView and they have forwarded it to the Qliktech support because the reproduce it, too.

So hopefully we will get an answer within the next few days.

Regards

AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Thu, 31 Mar 2011 07:02:53 GMT

Hi,

any news or reply from the QlikView Support?

Regards
Thomas

AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Thu, 31 Mar 2011 07:06:14 GMT

Unfortunately not so far.

Regards

AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: AW:Re: Macro parse failed

Mon, 04 Apr 2011 11:43:38 GMT

Hi,

short update from my side. I have now received an answer from QlikTech Support telling me, that the function ActiveDocument.CreateGroup is not supported on Server/Publisher ;-(

Thomas