Activate / deaktivate pivot expression by macro

[hugmarcel]

Hi

I have not found how to activate / deactivate a pivot formula (express) with an API macro. Any help?

Thx  a lot

Marcel

[CELAMBARASAN]

Hi,

     You can remove and add expression using below

rem ** delete second expression from chart CH01 **

set chart = ActiveDocument.GetSheetObject("CH01")

chart.RemoveExpression 1

set chart = ActiveDocument.GetSheetObject("CH01")

chart .AddExpression "sum(Amount)"

Celambarasan

[jagan]

Hi,

If you are using Qlikview 11 you can do this by Conditional enablement of expression in Expression tab.  No need of using Macro.

Hope this helps you.

Regards,

Jagan.

[hugmarcel]

Ok, nice to know the trick with QV 11. However, I am ussing QV 10 still.

How to add a label for the added expression then? I do not like to have ""sum(Amount)"" as label.

Thx - Marcel

[jagan]

Hi,

Hope the attached image helps you.

Regards,

Jagan.