I would really appreciate the example.
I spent a lot of time trying to create chart as below but was not able to export the data correctly.The gaps between countries were ruining the export somewhere between QV/NP/PPT.
This was in both 16 and 17 some time ago (before 17.3). I did not test it in recent versions.
Thanks in advance,
I did some tests in Excel and PowerPoint without involving NPrinting.
You can create an Excel bar chart with two dimensions and one measure only by using Excel pivot charts that are not supported by PowerPoint. So, in my opinion, it is not possible to create this kind of chart as a native PowerPoint chart with data from NPrinting.
In Office, as workaround, you can create an Excel pivot chart and copy and paste it into a PowerPoint.
As workaround you could try to create a single dimension by concatenating the two you want to use in the chart directly in the Qlik script, or by creating the pivot chart in Qlik and import it into the template as an image.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
it is possible in PPT/XLS without pivot chart. You just have to have specific underlying table. The first column of the dimension needs to have value only in first line and the rest blanks. Excel then automatically creates this type of chart. (It can be a bit tricky to get it right but it is possible).
But I was not able to get it right with NP.
Chart (screenshot from ppt)
Column1 Values Category 1 2016
2017 4,4 Category 2 2016 1,8 2017
we can achieve this in excel - you can create the custom template to achieve this without pivot table only.
you can create the same table columns with two rows of dummy data next line tags of designer columns
in between dummy data use <deleterow> tags and generate you will get the exact output.