topic Re: Expression label to bold by macro in QlikView

Expression label to bold by macro

Anonymous — Tue, 12 Dec 2017 08:34:57 GMT

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

m_woolf — Tue, 12 Dec 2017 12:45:19 GMT

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 — Tue, 12 Dec 2017 18:30:22 GMT

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 — Tue, 12 Dec 2017 20:39:16 GMT

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

Anonymous — Wed, 13 Dec 2017 15:22:50 GMT

Thanks again. It's really useful app.