Qlikview Object Model, Help Text / Comment fields in Properties

[hoodhill]

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

[Anonymous]

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]

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]

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]

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]

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

[hoodhill · Accepted solution]

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.