Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro to allow popup value in line chart

Hi everyone,

I am writing VB code in QV which creates an expression in an existing chart.

I delete the old expresion with:

  UCB1.RemoveExpression 0

The Create a new expresion with this:

  ExpNo = UCB1.AddExpression( "Sum(if ( ASAT = 'Monthend' AND BAND <> '<6 Months', fsB/1000))")

This works fine but I cannot find the code to enable the Text as pop up. When I delete the Expresion and create the new one it sets it to false.

I Getproperties earlier on in the code but when I reset them it overrites the expresion to the old one.

Any help would be appreciated!!

The closest I got was this:

 

SET UCB1 = activedocument.getsheetobject("UCB1")
SET pUCB1 = UCB1.GetProperties

pUCB1.chartproperties.Showpopuplabels = True

(I need to change the labels to the value. I'm not sure it is in 'chartproperties' but rather 'ExpressionVisualDef')

Many thanks

Scott

1 Solution

Accepted Solutions
Not applicable
Author

I sorted this problem.

Just for interest it was: data.expresionvisual.addexpression.showaspopup = 1

Regards

Scott

View solution in original post

2 Replies
Not applicable
Author

I sorted this problem.

Just for interest it was: data.expresionvisual.addexpression.showaspopup = 1

Regards

Scott

Not applicable
Author

If you are changing the expression based on your selections, then you achieve without Macro as well in QV 11 version.