Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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