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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Pivot Chart

I am attempting to re-create a Pivot Chart that I have in an Excel workbook. I understand how to build and utilize a Pivot Table within Qlik, but have not been able to find any documentation on a Pivot Chart. The chart I am trying to re-create is a combo chart with two dimensions and measures. Is this possible?

1 Solution

Accepted Solutions
Or
MVP
MVP

There is no such thing as a "pivot chart", per se - it's just how Excel refers to charts created using the Pivot Table mechanism. In Qlik, you would just use a regular chart of the matching type, in your case - Combo Chart.

As far as I know, Qlik Sense does not allow you to have two dimensions at the same time  in a Combo Chart, though two measures are fine. You can use one dimension and a second dimension can be used to color the first dimension, but that is the limit of what the native chart does. I am unsure if any extensions exist that would allow you to use two dimensions in a combo chart, but that might be an avenue worth pursuing if that requirement is important.

If you are just trying to have two dimensions that you can swap between but only one at a time is displayed,  you can of course use the "Alternative" dimension option.

View solution in original post

1 Reply
Or
MVP
MVP

There is no such thing as a "pivot chart", per se - it's just how Excel refers to charts created using the Pivot Table mechanism. In Qlik, you would just use a regular chart of the matching type, in your case - Combo Chart.

As far as I know, Qlik Sense does not allow you to have two dimensions at the same time  in a Combo Chart, though two measures are fine. You can use one dimension and a second dimension can be used to color the first dimension, but that is the limit of what the native chart does. I am unsure if any extensions exist that would allow you to use two dimensions in a combo chart, but that might be an avenue worth pursuing if that requirement is important.

If you are just trying to have two dimensions that you can swap between but only one at a time is displayed,  you can of course use the "Alternative" dimension option.