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: 
montubhardwaj
Specialist
Specialist

Fast Change using a button

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

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

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

View solution in original post

13 Replies
Anonymous
Not applicable

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.

montubhardwaj
Specialist
Specialist
Author

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

SunilChauhan
Champion
Champion

see the attached file

hope this helps

Sunil Chauhan
SunilChauhan
Champion
Champion

or

you can see this attached file

hope this will help

Sunil Chauhan
m_woolf
Master II
Master II

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

montubhardwaj
Specialist
Specialist
Author

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

montubhardwaj
Specialist
Specialist
Author

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

m_woolf
Master II
Master II

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

SunilChauhan
Champion
Champion

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.

Sunil Chauhan