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

[#1]

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

[Anonymous]

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

[#3]

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?