Change chart using button Object

[robert99]

Changing chart using for example a button object

Example. If I want to change a Pivot Table chart from 'Subtotals at bottom' to 'Subtotals at top'

Or remove 'Show partial sums'

I can do this by going into chart properties

But can this be done  by setting up a (say) text or button object and clicking on the object once set up

I sure it can be done but I can not see how

Thanks

[MarcoWedel]

You could trigger some VB script with the button and edit the chart properties there.

Regards

Marco

[MarcoWedel]

If you don't know it already, maybe the API documentation might help you implementing this code.

You can find it e.g. here:

QlikView Core COM API Guide - Version 11

http://community.qlik.com/servlet/JiveServlet/downloadBody/2640-102-2-3064/APIguide.qvw

[robert99]

Thanks

But I'm unsure what this means. Is this linked to macro's???

[MarcoWedel]

Yes, it means writing a macro in vbs that does the job.

[robert99]

OK thanks. I'm not great with VBS yet but will have to learn when I have time

[#7 · Accepted solution]

HI RJ ,

you Can Do this By Setting A variable

and Creating Two Chart one for Sub total at Bottom And Other For Sub totals At top

i Have Done This in Sample App

please find

hope this Helps

[giakoum]

Here is the macro that changes chart type for example. You can use the automation help pdf to make your own changes. But generally speaking, avoid macros. Not a good choice.

Enjoy!

[MarcoWedel]

I agree, your solution is by far easier than writing some macro

regards

Marco

[fkeuroglian]

Hi, using variables and show and hide two different chart is the best option

good luck

Fernando