Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create charts on the fly from script engine

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 ?

3 Replies
johnw
Champion III
Champion III

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
.

Not applicable
Author

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.