Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I am looking to get selections cleared and default page set when publisher reloads data, as presently if the document is saved with selections by mistake that default selection persists until someone sorts it out.
I have attempted a solution that goes like this:
Created a variable osUser, with a value of =OSUser()
Set OnPostReload event to fire PublisherClearSelections
Created the macro PublisherClearSelections as below
sub PublisherClearSelections
vOSUser = ActiveDocument.GetVariable("osUser").GetContent.string
if instr(vOSUser, "QVPublisher") > 0 then
ActiveDocument.ClearAll
ActiveDocument.ActivateSheet("Home")
end if
end sub
Steve,
Marcos cannot be ran by publisher. QVS 9 reference manual page 224. "
QlikView Distribution Service does not execute any macros that may exist in
the Source Document."
You could do an "on open" marco that when the document is open it would do these. Then the server went it open the document would run the macro.
Steve,
Marcos cannot be ran by publisher. QVS 9 reference manual page 224. "
QlikView Distribution Service does not execute any macros that may exist in
the Source Document."
You could do an "on open" marco that when the document is open it would do these. Then the server went it open the document would run the macro.
Hi there,
Well spotted on the fact that publisher will not execute macros.
Your suggestion of using OnOpen works fine.
Many thanks,
Steve
Guys
I have another problem.
At present, i'm using QT for polling data from a number of xls file and have a marco that inserts this data into our forecast system. The issue is my reload runs via the server but someone has to open the qvw to push the button to insert the data into the database.
Can this all run via the server?