topic Create charts on the fly from script engine in QlikView

Create charts on the fly from script engine

Thu, 12 Nov 2009 20:25:46 GMT

I wonder if there is a possibility to create charts and define expression and dimensions on the fly, by reading a XML file in QlikView ?

Create charts on the fly from script engine

johnw — Fri, 13 Nov 2009 02:14:46 GMT

I think you'd load in the XML file, then trigger a macro. The macro would use the XML data to control what API calls it makes to build the charts. Complex and not something I'd attempt, but it should be possible.

Create charts on the fly from script engine

rwunderlich — Sat, 14 Nov 2009 00:44:05 GMT

If you have the correct XML, you can create new objects by reading the file with the API member Sheet.CreateObjectFromXmlPropertiesFile.

You can get a create a model of the required XML by writing out an existing object with Sheet.WriteXmlPropertiesFile.

I'm not sure how CreateObjectFromXmlPropertiesFile would behave in the Server environment. My guess is that you would create a user object.

-Rob
.

Create charts on the fly from script engine

Tue, 24 Nov 2009 18:01:04 GMT

Thanks for your answers.

The reason of this approach, is to create a generalized application where the number of elements are unknown, but where the nodename is known.

Read the unknown elements and then make a aggregated chart by using the unknown elements.

I am reading a webservice, saving the elements in the database by using a QlikView and then later on Load those elements in a predefined number of charts.

I wonder how stable the reload service is ? For the moment both services are disconnected in the Managment Console. I have allready put SR2 on the server with nu success at all.