Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
robert99
Specialist III
Specialist III

Change chart using button Object

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

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

12 Replies
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
Specialist III
Specialist III
Author

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
Specialist III
Specialist III
Author

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

Not applicable

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
Partner - Master II
Partner - Master II

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
Partner - Master
Partner - Master

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

good luck

Fernando