topic Re: Change chart using button Object in QlikView

Change chart using button Object

robert99 — Sun, 23 Mar 2014 10:49:04 GMT

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

Re: Change chart using button Object

MarcoWedel — Sun, 23 Mar 2014 11:22:43 GMT

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

Regards

Marco

Re: Change chart using button Object

MarcoWedel — Sun, 23 Mar 2014 11:25:40 GMT

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

Re: Change chart using button Object

robert99 — Sun, 23 Mar 2014 11:58:30 GMT

Thanks

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

Re: Change chart using button Object

MarcoWedel — Sun, 23 Mar 2014 12:40:51 GMT

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

Re: Change chart using button Object

robert99 — Sun, 23 Mar 2014 15:01:13 GMT

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

Re: Change chart using button Object

Sun, 23 Mar 2014 15:41:27 GMT

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

Re: Change chart using button Object

giakoum — Sun, 23 Mar 2014 16:12:22 GMT

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!

Re: Change chart using button Object

MarcoWedel — Sun, 23 Mar 2014 21:55:43 GMT

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

regards

Marco

Re: Change chart using button Object

fkeuroglian — Sun, 23 Mar 2014 22:14:54 GMT

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

good luck

Fernando

Re: Change chart using button Object

Anonymous — Sun, 23 Mar 2014 22:41:07 GMT

Agreed. "Thou shall not use Macro's" is one of the 5 missing commandments.

Re: Change chart using button Object

robert99 — Mon, 24 Mar 2014 17:43:03 GMT

Thanks

I have done this before but I'm using an adhoc report and I was trying to avoid using another report

But if Macros are too be avoided and this is the only other way to do it (macros) I will do it this way

Re: Change chart using button Object

robert99 — Mon, 24 Mar 2014 17:47:31 GMT

Thanks

I would have used this but will avoid macros.