Pivot Chart

evansabres — Fri, 15 May 2020 19:27:53 GMT

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?

Re: Pivot Chart

Or — Fri, 15 May 2020 19:37:03 GMT

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.

topic Pivot Chart in App Development

Pivot Chart

Re: Pivot Chart