topic value field in Pivot table not work in Qlik NPrinting

value field in Pivot table not work

cimxfang — Fri, 27 Sep 2019 04:36:37 GMT

Hi Guys,

I have a straight table with three columns:

event day, data_source, eventcount

and would like to make a stacked bar chat with event day as x axis and eventcount grouped by data_source as stacked bar.

Hence, concert it into a pivot chart as below, however I find the eventcount field is always 0 although I put "Sum" there.

I was thinking there are no data for eventcount, which makes it 0, but we do have values for eventcount.

Not sure why it sum (events_by_datasource) all become 0 once the table is converted into pivot.

Re: value field in Pivot table not work

Frank_S — Fri, 27 Sep 2019 14:35:58 GMT

Hi @cimxfang

It's not clear what you are trying to accomplish.

Are you trying to make a pivot table as shown in the images or as you also mentioned you are trying to create a stacked bar chart.

Are you trying to do this in an NPrinting report with QlikView or Qlik Sense data or some other data source?

Note that if you are trying to make a pivot table chart with QV or QS data exclusively, please check the following article. It has to be followed accurately or it will not work.

https://help.qlik.com/en-US/nprinting/September2019/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm

If you are trying to do another requirement, there are many existing tutorials that can be found here:

https://help.qlik.com/en-US/nprinting/September2019/Content/NPrinting/ExcelReports/Intro-Excel.htm

There are also several videos that 'might' have what you need. Please explore the Qlik NPrinting videos here: https://help.qlik.com/en-US/videos. Choose 'Qlik NPrinting' to access the videos.

If you need advance assistance with your requirement, you may wish to reach out to consulting services here. https://www.qlik.com/us/services/qlik-consulting

Kind regards...

Re: value field in Pivot table not work

Lech_Miszkiewicz — Sat, 28 Sep 2019 06:52:13 GMT

this looks to me like your data comes out to your excel template as text not as numbers hence it is not additive.