topic Activate / deaktivate pivot expression by macro in QlikView

Activate / deaktivate pivot expression by macro

hugmarcel — Tue, 13 Mar 2012 13:40:09 GMT

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

Thx a lot

Marcel

CELAMBARASAN — Tue, 13 Mar 2012 13:49:23 GMT

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 — Tue, 13 Mar 2012 13:54:14 GMT

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 — Tue, 13 Mar 2012 14:22:51 GMT

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 — Tue, 13 Mar 2012 14:55:49 GMT

Hi,

Hope the attached image helps you.

Regards,

Jagan.