topic Re: How to run a sub in VBscript in QlikView

How to run a sub in VBscript

Fri, 27 Jun 2014 16:25:10 GMT

For a try, I wrote this routine in VBScript

sub cleanUp()

defaultSelections()

set revSheet = ActiveDocument.Sheets("Revenues Summary")

set Pivot = revSheet.CreatePivotTable

Pivot.addDimension "Portfolio"

end sub

How to run the sub so that the object is created in the "Revenues Summary" sheet ?

Is the syntax for adding dimension appropriate ? How can I add as a dimension a field of the document (Portfolio field) ?

How can I debug this piece of code ? Will it exit with no message if there is some syntax mistake ?

Is it at all possible to launch a script in the Personal Edition ?

Thanks

Re: How to run a sub in VBscript

vgutkovsky — Fri, 27 Jun 2014 16:50:20 GMT

To run the sub, create either a button or a text object. Add an Action by going to the Action tab >> External >> Run Macro. Enter the name of the sub.

You can do a basic debug by pressing the "Check" button in the Edit Module dialog.

Regards,

Vlad

Re: How to run a sub in VBscript

Fri, 27 Jun 2014 16:54:44 GMT

Thanks, is it also possible in the Personal Edition (see my other post)

Re: How to run a sub in VBscript

vgutkovsky — Fri, 27 Jun 2014 16:59:35 GMT

Yes, doesn't matter if it's personal edition or licensed.

Vlad