Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

13 Replies
m_woolf
Master II
Master II

SetChartType must have FastChange enabled.

Can you just not show the caption?

Not applicable

It works perfectly! Thanks for the information mwoolf

Not applicable

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.

emiledavis
Contributor III
Contributor III

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.