Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Is it possible to control the sheet or document in script?

Hello Expert,

Is there a way to treat QlikView as Excel through Script?

For example, I can write VBA to control the whole workbooks of excel and of course to control the sheets or cells.

I tried to find such kind of function in QlikView but did not get the way.

The requirement is to generate a dynamic pivot chart(some of the dimentions will be or be not displayed against data set), if there is a way to control the object in sheet of QlikView, it would be possible.

Thanks

HTC

2 Replies
jsn
Honored Contributor

Re: Is it possible to control the sheet or document in script?

Sure is. Search for the API Guide on the community and download for examples on different API calls for QlikView.

Not applicable

Re: Is it possible to control the sheet or document in script?

Is it saying we donot have ability to control the object in Script section of QlikView document itself?

For example, I write one command like in Excel but it wont work.

     For each object in ActiveSheet;

     Next object;

Is there equivalent thing like ActiveWorkbooks or Activesheet in QlikView document?