topic Re: Bar chart doesn't work in Qlik NPrinting

Bar chart doesn't work

Ethel — Wed, 16 Nov 2022 16:20:13 GMT

Hello, I'm trying to create a bar chart in NPrinting using table data

My data looks like this

PeriodYear	1	Name
<PeriodYear>	<if('$(=minstring(PercentCount))'= 'Count',num(avg({ $(vPeriodType), PeriodYear= {"=$(=vPriorFiveYear)=$(=vPeriodYear)"},TimeFrame = {'Current Year'}}aggr(sum({$(vPeriodType), PeriodYear= {"=$(=vPriorFiveYear)=$(=vPeriodYear)"},TimeFrame = {'Current Year'}}[# HeadCount]),[%PeriodSKey], Gender)),'###,##0'),num(sum({ $(vPeriodType), PeriodYear={"=$(=vPriorFiveYear)=$(=vPeriodYear)"}, TimeFrame = {'Current Year'}[# HeadCount])/sum(total PeriodYear{$(vPeriodType), PeriodYear={"=$(=vPriorFiveYear)=$(=vPeriodYear)"}, TimeFrame = {'Current Year'}[# HeadCount]),'#,##0.0%'))>	<=Gender>

My bar chart looks like this

(Columns for each year are apart, not together). I tried to play with powerpoint setting, nothing helps. I think that Npriting treat my data this strange way. Is there anything that can be done? I also tried to use stack chart instead of bar chart, but NPrinting replaces stack chart with bar chart. Thanks a lot in advance!

That's how it should look like

Thanks a lot in advance!

Re: Bar chart doesn't work

Lech_Miszkiewicz — Thu, 17 Nov 2022 09:22:21 GMT

Are you using PowerPoint Template?
Screenshot is not from PowerPoint template so where is it from?
Below are the steps I made in Power Point and it works as designed

Now the steps

add some dummy data to the template so series becomes visible
edit series as per your requirements
use GAP Width and Series Overlap to get required results
Once you happy remove previously added records from template

Re: Bar chart doesn't work

Ruggero_Piccoli — Thu, 17 Nov 2022 11:12:08 GMT

Hi,

You have to define the data series in the PowerPoint template

Select the correct type of native PowerPoint chart, for example, cluster bar chart, and run a preview:

Refer to https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PowerPointReports/Chart-Native-Tables.htm

Best Regards,

Ruggero

Re: Bar chart doesn't work

Ethel — Thu, 17 Nov 2022 12:24:09 GMT

Hello, thank you very much for your help.

I'm using power point template. I clicked insert chart->edit data, and changed data in excel to my data. Maybe I should do something else?

If add dummy data

that's my result, columns are not near each other.

Thank you very much again!

Re: Bar chart doesn't work

Ruggero_Piccoli — Thu, 17 Nov 2022 13:10:17 GMT

Hi,

Could be a problem of the selected type of chart? Try to generate a preview with data from Qlik NPrinting and open that data source of the chart from the generated file. Check that all needed rows are included and that the type of chart is correct. You can also try to edit the chart there with your real data to understand what could be the issue.

Best Regards,

Ruggero

Re: Bar chart doesn't work

Ethel — Thu, 17 Nov 2022 16:21:50 GMT

Thank you! Data from Nprinting is working fine, but my data gives weird results unfortunately:( I need bar chart and in Qlik sense bar chart worked fine. I converted existed bar chart to the table and imported that table in NPrinting. v Any other ideas what I can do to make it work?

Thank you very much for your help!!!

Re: Bar chart doesn't work

Ethel — Thu, 17 Nov 2022 17:47:46 GMT

I think the difference in your example and mine is that I have only one measure (totals) and two dimensions (gender and year). Is it possible to create this type of chart? Or should I have only one dimension?

Thanks a lot in advance!

Re: Bar chart doesn't work

Lech_Miszkiewicz — Fri, 18 Nov 2022 00:36:13 GMT

I was never able to pivot data in nprinting ppt chart so the solution for what your requirement is would be to use set analysis for "Male" and "Female" measures.