topic Fast Change using a button in QlikView

Fast Change using a button

montubhardwaj — Thu, 13 Oct 2011 10:03:39 GMT

Hi All,
I have a Line chart and it has Fast Change functionality to change it to Pivot table also. In place of clicking the "Fast Change" icon in caption, I want to have a button which will change the chart type from Line to Pivot and vice-versa.
Can anyone provide me the macro code/technique how to do it in best possible way?
I have provided a sample qvw here.

Regards,
Sharma

Re: Fast Change using a button

Anonymous — Thu, 13 Oct 2011 11:12:42 GMT

Hi Sharma,

I don't know the code you are asking for, but i tried some other options to get the same result.

Take a look at the atteched file and tell me what you think ok?

Good luck,

Dennis.

Fast Change using a button

montubhardwaj — Thu, 13 Oct 2011 11:35:35 GMT

Thanks for looking into this Dennis. I can see that you have got two different charts and the button is just changing the charts. But I dont want this. I will have only one chart and I want to trigger the Fast change on the press of a button i.e. If I Press the button, the chart should change from Line to Pivot table and vice versa.

I dont want to do this with two charts.

Regards,

Sharma

Re: Fast Change using a button

SunilChauhan — Thu, 13 Oct 2011 11:45:16 GMT

see the attached file

hope this helps

Re: Fast Change using a button

SunilChauhan — Thu, 13 Oct 2011 12:24:16 GMT

you can see this attached file

hope this will help

Re: Fast Change using a button

m_woolf — Thu, 13 Oct 2011 12:58:24 GMT

Try this attachment:

Experimentation will tell you the chart types.

The object types are:

0=Unknown

1=List Box

2=Multi Box

3=Statistics Box

4=Table Box

5=Button

6=Text Object

7=Current Selections Box

8=Input Box

9=Line/Arrow Object

10=Pivot Table

11=Straight Table

12=Bar Chart

13=Pie Chart

14=Scatter Chart

15=Line Chart

16=Combo Chart

17=Custom Object

18=Bookmark Object

19=Slider/Calendar Object

20=Grid Chart

21=Radar Chart

22=Gauge Chart

Fast Change using a button

montubhardwaj — Thu, 13 Oct 2011 13:13:50 GMT

Hi Sunil,

Thanks for you effort on this. But as I said earlier, I dont want to use two charts. I want to have only one chart and since Fast change options are checked, I want to suffle between line and Pivot table by the use of button(as if clicking on Fast Change icon on title bar).

Thanks

Sharma

Fast Change using a button

montubhardwaj — Thu, 13 Oct 2011 13:26:20 GMT

Hello mwoolf,

This is working great and is what I needed. Nice concept though. Thanks for this.

But I just want to know about the integer you have set in the code like below:

chart.SetChartType 2

chart.SetChartType 4

How you have arrived at these numbers? Also if you see from the list you have given up, there is no relation. Your explanation will of very much help.

Regards,

Sharma

Fast Change using a button

m_woolf — Thu, 13 Oct 2011 13:27:45 GMT

FastChange Chart Types

0=Bar

1=Pie

2=Pivot

3=Scatter

4=Line

5=Straight Table

6=Combo

7=Radar

8=Gauge

9=Grid

10=Block

11=Funnel

Re: Fast Change using a button

SunilChauhan — Thu, 13 Oct 2011 13:42:40 GMT

mwoolf its not working hwen we remove the fas change option i.e icon on title bar of chart.

is there any example for without check for fast change.

Re: Fast Change using a button

m_woolf — Thu, 13 Oct 2011 14:01:32 GMT

SetChartType must have FastChange enabled.

Can you just not show the caption?

Re: Fast Change using a button

Tue, 20 Nov 2012 14:13:43 GMT

It works perfectly! Thanks for the information mwoolf

Re: Fast Change using a button

Fri, 23 Oct 2015 20:31:09 GMT

Hi, thank u so much for this, u save my life, also wanna know where is chart type from ?, is a rule for qlikview or is a standard rule, each number for each chart. And in the qvw file where is saved chart type list ?.

Thanks again.

Re: Fast Change using a button

emiledavis — Tue, 07 Aug 2018 22:42:02 GMT

I may be late in the game here, but here are my thoughts...

So you're saying that you don't want the fast-change button on the caption but still want the macro to work. To do this, add a new couple lines in the macro that:

1) sets the chart again (same as what you probably did before)

2) set all of the chart types to false

You are basically repeating the macro but now turning off all the fast-change functionality. There could very well be a more elegant solution, but this works.

Make sure this is at the end of the macro. This way, running the macro will first set the fast change type as you desire. Then, it will remove all possible fast change types. The removal of the fast-change types is what pulls that button off of the caption.