Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have not found how to activate / deactivate a pivot formula (express) with an API macro. Any help?
Thx a lot
Marcel
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
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.
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
Hi,
Hope the attached image helps you.
Regards,
Jagan.