Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression label to bold by macro

Hi, everybody. How to bold the expression label using macro?

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

From the API:

set chart = ActiveDocument.ActiveSheet.CreateStraightTable

chart.AddDimension "Customer"

chart.AddDimension "ProductType"

chart.AddExpression "sum(Amount)"

set cp = chart.GetProperties

set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.Label.v = "Sales"

expr.LabelAdjust = 2

expr.VisualCues.LowLimit.v = 10

expr.VisualCues.LowCue.Color.Col = RGB(255,0,0)       'red

expr.VisualCues.LowCue.FontStyleMod = 2           'bold

expr.VisualCues.LowCue.SizeMod = 1                '+20%

chart.SetProperties cp

View solution in original post

4 Replies
m_woolf
Master II
Master II

From the API:

set chart = ActiveDocument.ActiveSheet.CreateStraightTable

chart.AddDimension "Customer"

chart.AddDimension "ProductType"

chart.AddExpression "sum(Amount)"

set cp = chart.GetProperties

set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.Label.v = "Sales"

expr.LabelAdjust = 2

expr.VisualCues.LowLimit.v = 10

expr.VisualCues.LowCue.Color.Col = RGB(255,0,0)       'red

expr.VisualCues.LowCue.FontStyleMod = 2           'bold

expr.VisualCues.LowCue.SizeMod = 1                '+20%

chart.SetProperties cp

Anonymous
Not applicable
Author

Yes, that's exactly what I need. Thanks a lot.

But, what API did you read that in?.  I saw no answer there.




m_woolf
Master II
Master II

The API Guide I was referring to is a QV app. I have pasted it for your review.

Anonymous
Not applicable
Author

Thanks again. It's really useful app.