topic Re: Qlikview Object Model, Help Text / Comment fields in Properties in QlikView

Qlikview Object Model, Help Text / Comment fields in Properties

hoodhill — Tue, 29 Apr 2014 11:25:25 GMT

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

Re: Qlikview Object Model, Help Text / Comment fields in Properties

Anonymous — Tue, 29 Apr 2014 12:18:57 GMT

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

Re: Qlikview Object Model, Help Text / Comment fields in Properties

hoodhill — Tue, 29 Apr 2014 13:14:40 GMT

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

Re: Qlikview Object Model, Help Text / Comment fields in Properties

Anonymous — Tue, 29 Apr 2014 13:51:26 GMT

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" (?)

Re: Qlikview Object Model, Help Text / Comment fields in Properties

hoodhill — Tue, 29 Apr 2014 13:58:30 GMT

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

Re: Qlikview Object Model, Help Text / Comment fields in Properties

Anonymous — Tue, 29 Apr 2014 15:48:02 GMT

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

Re: Qlikview Object Model, Help Text / Comment fields in Properties

hoodhill — Fri, 13 Jun 2014 15:49:51 GMT

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.