Discussion Board for collaboration on QlikView Integration.
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
Then I add all expressions and change a Comment
myLine = 1
While Cells(myLine, 4) <> ""
cond = Cells(myLine, 4)
myExpr = Cells(myLine, 19)
Set pq = o.GetProperties
Set expr = pq.Expressions.Item(myLine - 1).Item(0).Data.ExpressionData
expr.Comment = "test"
myLine = myLine + 1
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 ?