Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.