Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table to pie-chart settings to change

Hi,

I am using a Pivot table and would like to convert it into a Pie-chart using the Fast change button.

Now, when I am viewing the chart in pie-chart mode I would like to ignore one of the dimensions(although I would like to view it in Pivot table).

How can this be achieved.

Regards,

Rohit

2 Replies
spsrk_84
Creator III
Creator III

Hi,

As you are saying like when the chart type changed from Pivot table to Pie u want to ignore one of the dimension which is not possible but u can do like this

i.e Create a macro for converting the Pivot Table to Pie-Chart instead of fast change.

Write the macro code like , on the click of the button it should convert the existing pivot table to Pie Chart by removing one of the dimension which is not required ,Similarly when u want the Pivot table from the same piechart add one Dimension that is required...

Try to achieve taht if it works well and good..........

Regards

Ajay

johnw
Champion III
Champion III

If you're clicking a button to do it, might as well just have two separate charts, one a pivot table with the column, one a pie chart without it. Just have the button set a variable, and check the variable in each chart to see whether to display the chart or not. You can probably make the button completely transparent and put it on top of the fast change icon, so that when someone thinks they're pressing the fast change button, they're actually pressing your button.