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

AddExpression resulting in a "crossed" table

I am trying to make an AddExpression clause work (StraightTable) and end up with the table "overcrossed".

After opening the object, and then closing it again, without any further action, the presentation is ok.

can anyone tell me what is causing this ?

set Graph = ActiveDocument.GetSheetObject("CH01")
x = Graph.AddExpression ("count(Team)")

Alex

2 Replies
Not applicable
Author

i have the same issue using pivottable.
i'm trying to add an expression to a pivoit table using the following code:

ActiveDocument.GetSheetObject("chart2").AddExpression "count(distinct UnitItemID)"

but then get the "crossed" image on the pivot table.

If i edit the pivottable and simply click OK - the pivot works.

i guess additional properties needs to be set to the new expression, but i found no reference for how to do that.

Alex, have you found a solution for this issue ?

Not applicable
Author

Hi yani...

I still have no solution to my problem, but I also stopped searching for one.

Seems the next release is offering features making the reason why I was using macros unnecessary.

Perhaps it is the same for you,

Alex