Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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)")


2 Replies
Not applicable

AddExpression resulting in a "crossed" table

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

AddExpression resulting in a "crossed" table

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,


Community Browser