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

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

Mon, 10 Dec 2012 07:30:55 GMT

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

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

Anonymous — Mon, 10 Dec 2012 07:41:00 GMT

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

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

Mon, 10 Dec 2012 08:57:05 GMT

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?