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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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