Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm always amazed by the power of using QlikView through VB Macro but the lack of documentation and examples about it.
I'm trying to create a line chart with conditional expressions through VB (to quickly add 50 conditional expressions)
I'm able to remove all expressions
Set o = mydoc.GetSheetObject("CH349")
For i = 0 To o.GetProperties.Expressions.Count - 1
o.RemoveExpression (0)
Next
Then I add all expressions and change a Comment
myLine = 1
While Cells(myLine, 4) <> ""
cond = Cells(myLine, 4)
myExpr = Cells(myLine, 19)
o.AddExpression (myExpr)
Set pq = o.GetProperties
Set expr = pq.Expressions.Item(myLine - 1).Item(0).Data.ExpressionData
expr.Comment = "test"
o.SetProperties pq
myLine = myLine + 1
Wend
But now I would like to change the Caption of these Expressions AND to add a conditional expression for each of them
how can I do ?
Thanks