Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Partner
Partner

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.

Highlighted
Specialist
Specialist

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

Highlighted
Champion
Champion

see the attached file

hope this helps

Highlighted
Champion
Champion

or

you can see this attached file

hope this will help

Highlighted
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

Highlighted
Specialist
Specialist

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

Highlighted
Specialist
Specialist

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

Highlighted
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

Highlighted
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.