Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you have section access? in my case i noticed that macros return that error when I use user login. As admin it works fine.
Anyone knows any option which must be "unticked" ? 🙂
Hi,
Does that work when you access via client? All users are granted USER access even if stated otherwise in section access code.
Regards.
It works on the server when I open document as an user in qlikview but doesnt work with IE plugin - i've tried both browsers - on server and client.
Hi AndreBer,
I am having a problem which is very similar to your post question.
In your Macro code instead of entering the fields by manually, i need to get the fields which are selected in listbox that fields should be save into group.
See below your code in that place i need to have currently selected fields as group.
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
Pls send me with attachement how it can be worked.
Thnks in advance
Hi AndreBer,
I am having a problem which is very similar to your post question.
In your Macro code instead of entering the fields by manually, i need to get the fields which are selected in listbox that fields should be save into group.
See below your code in that place i need to have currently selected fields as group.
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
Pls send me with attachement how it can be worked.
Thnks in advance
ANY NEWS ON THIS? WHAT IS THE SOLUTION??
I have a Qlikview that works fine if I open it from the on the server itself, but if i go in through the client I get "Allocated Memory Exceeded" Error. and the server disconnects.
I have deleted all the macros that used to run on this QVW, but still ahve the error.
ANy suggestions?