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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hoodhill
Partner - Contributor II
Partner - Contributor II

Qlikview Object Model, Help Text / Comment fields in Properties

Hi,

Does anyone know whether its possible to get/set the values of the 'Help Text' / 'Comment' fields by using the Qlikview API; re. I can pick up Captions, Cell information etc, but there seems to be no reference to the fields I want.

Background. I want to populate the 'Help Text' / 'Comment' fields of a BI implementation and I thought it might be easier to write a script to do this as opposed to manually go through all the objects within the presentation and make the change. Would also be easier if I wanted to do a mass change of the details at some future point too.

BTW. If not possible to use the API is their any other way to achieve the same thing?

Regards,

Tim

1 Solution

Accepted Solutions
hoodhill
Partner - Contributor II
Partner - Contributor II
Author

Figured this out a while back.... code required for say expression comments is as follows:

boxprop.expressions.item(iy).item(0).data.expressiondata.comment

boxprop.expressions.item(iy).item(0).data.expressionvisual.label.v

if you go through the APIGuide.qvw you eventually get there.

View solution in original post

6 Replies
Anonymous
Not applicable

Tim,

Here are the examples from API Guide:

rem ** Set pop-up help text for list box **
set LB = ActiveDocument.GetSheetObject("LB06")
set boxprop=LB.GetProperties
boxprop.Layout.Frame.HelpText.v = "Bla bla bla"
LB.SetProperties boxprop

rem ** Set pop-up help text for a chart **
set g = ActiveDocument.GetSheetObject("CH01")
set gp = g.GetProperties
gp.GraphLayout.Frame.HelpText.v = "Bla bla bla"
g.SetProperties gp


hoodhill
Partner - Contributor II
Partner - Contributor II
Author

Hi Michael,

Thanks – works a treat with the HelpText.

In terms of the ‘Comment’ field(s), how do I get to those; re. looking to get a list of comment(s) for the cells in a chart.

Thanks in advance.

Regards,

Tim

Anonymous
Not applicable

I found how to read field comments, but not how to change it.

Somewhat confused about "list of comment(s) for the cells in a chart".  Doesn't look like "field comments" (?)

hoodhill
Partner - Contributor II
Partner - Contributor II
Author

Hi Michael,

From the Chart properties, the ‘Comment’ field.

Assuming it’s possible, what I’d like back is the value ‘Suppliers-Comment’.

Thanks in advance.

Regards,

Tim

Anonymous
Not applicable

I see...  No, I don't know if there is API for this.

hoodhill
Partner - Contributor II
Partner - Contributor II
Author

Figured this out a while back.... code required for say expression comments is as follows:

boxprop.expressions.item(iy).item(0).data.expressiondata.comment

boxprop.expressions.item(iy).item(0).data.expressionvisual.label.v

if you go through the APIGuide.qvw you eventually get there.