topic Re: I require an answer to locked discussion: macro dimension in QlikView

I require an answer to locked discussion: macro dimension

chrweber — Thu, 14 Jun 2018 11:58:23 GMT

How can I access the DimensionExpression

Best Regards

sunny_talwar — Thu, 14 Jun 2018 12:29:48 GMT

May be this

vDimension = ActiveDocument.Evaluate("GetObjectField(0, 'CH01')")

msgbox vDimension

Updated the dashboard from that thread to show how it will work.

chrweber — Thu, 14 Jun 2018 12:32:20 GMT

And how can I set the dimenson via macro?

I require the actual field that contains dimension string.

Von meinem Samsung Galaxy Smartphone gesendet.

sunny_talwar — Thu, 14 Jun 2018 12:38:32 GMT

I require the actual field that contains dimension string.

Not sure I understand this?

chrweber — Thu, 14 Jun 2018 13:42:32 GMT

I have to define, edit the dimension of a chart using com interface, or VBA.

The sample provided in the discussion shows how to access editable field in charts, i.e. title.

The actual dimension is nowhere to be found.

I would have expected Totalstring to be the field I require, as the docu suggest s as much, but that field is empty.

Von meinem Samsung Galaxy Smartphone gesendet.

chrweber — Thu, 14 Jun 2018 14:26:57 GMT

Yay, I Found the solution. And I must complain, that the necessary information is horribly hidden:

The Path is

$dimension.PseudoDef().Name ="123"

I found it by checking the generated xml files of the *-prj folder

sunny_talwar — Thu, 14 Jun 2018 14:43:42 GMT

Superb