Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You could trigger some VB script with the button and edit the chart properties there.
Regards
Marco
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
Thanks
But I'm unsure what this means. Is this linked to macro's???
Yes, it means writing a macro in vbs that does the job.
OK thanks. I'm not great with VBS yet but will have to learn when I have time
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
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!
I agree, your solution is by far easier than writing some macro
regards
Marco
Hi, using variables and show and hide two different chart is the best option
good luck
Fernando