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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
asgardd2
Creator III
Creator III

How to change the definition of a dimension (not label(title)) with macro

Hello!

     I can change dimension label in pivot table(with macro), but i didn't find solution to change the  definition of a dimension.

How i can do it?

To change label i'm using code, like this:

set chart = ActiveDocument.GetSheetObject("CH47")

set p = chart.GetProperties

set dims = p.Dimensions(i)

dims.Title.v = "test"

chart.SetProperties p

Best Reagrds,

Anton Aleksandrov

0 Replies