topic Re: Access the Comment in any expression in QlikView

Access the Comment in any expression

sgrice — Fri, 24 Jul 2015 07:57:15 GMT

Can I get the value of the comment line in code?

For a given expression I want to be able to get the Value of the

"Comment"

or the value of the label? without knowing the column number.

Re: Access the Comment in any expression

swuehl — Fri, 24 Jul 2015 08:06:39 GMT

Without knowing the column number or the label, how do you want to tell QV which expression to look for?

Re: Access the Comment in any expression

sgrice — Fri, 24 Jul 2015 08:12:04 GMT

Because the expression can access the row above below. SO it can self reference.

But how can I get it's own Comment or Label?

Re: Access the Comment in any expression

swuehl — Fri, 24 Jul 2015 08:27:59 GMT

I don't think there is a QV function to access these information within an expression.

You can duplicate the label / comment in the expression or reference the same source (e.g. a variable).

What do you want to do with these information in the expression, maybe there are some alternatives?

Re: Access the Comment in any expression

marcus_sommer — Fri, 24 Jul 2015 08:39:43 GMT

Unfortunately qv had not implemented an object-API within the gui so that a reference like the following would work:

me.ObjectID

me.Name

me.ParentID

me.Properties

...

In general you could get such informations per vbscript but it would be need a lot of efforts to build a stable solution with macro-triggers or the enabling of macro-functions within gui-objects. Beside them see: Macros are Bad.

Therefore you will need some workaround.

- Marcus