Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dnt503
Contributor II
Contributor II

How to convert pivot table to a combo chart

Hello everyone,

I'm trying to convert the data from the pivot table below into a combo chart (sample below). Is there a way to show that with just the Year, Number of Tickets, and Percentage Change?

 

kimdiep503_0-1709672925324.png

kimdiep503_2-1709673605704.png

 

 

 

Labels (4)
1 Reply
pravinboniface
Creator II
Creator II

One way to do it- duplicate the pivot table and keep only the dimension and the two measures you need in the table.  Then drag the combo chart from the assets panel and drop it on the pivot table, and choose convert to combo chart.  You can adjust the properties on the combo chart after that.