topic Re: Getting a Qlik Sense Pivot table in nPrinting in Qlik NPrinting

Getting a Qlik Sense Pivot table in nPrinting

Anonymous — Fri, 07 Apr 2017 16:06:36 GMT

nPrinting Version 17.3, Qlik Sense Version 3.0 SR3

Currently have a Pivot Table set up in Qlik Sense, and was looking for ways to bring this information in to a nPrinting Excel report.

I've established my connection and am in the nPrinting Designer but the pivot table object does not appear in the Item Master List under Level's or Tables.

Can you really not bring Qlik generated Pivot Tables in to nPrinting? I saw the tutorial in how to manipulate a Straight table to make it in to a Pivot table in excel, but i'd rather not have to create a separate object just for nPrinting to grab the data that i need and generate the object.

I saw the object appears under the Images but that is not what i want because i want to be able to create a chart using the data in the table.

So my question is, do i need to create a totally separate straight table just for this data, so that i can bring it in to excel and then create the pivot table in excel, then create the chart using the data. Or is there a way i can just bring the pivot table from Qlik Sense?

Thanks for any help or guidance!

Re: Getting a Qlik Sense Pivot table in nPrinting

ogster1974 — Fri, 07 Apr 2017 22:37:19 GMT

Piviot table not currently supported in nprinting 17 you need to use a straight table.

Re: Getting a Qlik Sense Pivot table in nPrinting

kakaderanjit53 — Sat, 08 Apr 2017 18:25:47 GMT

Hello Gregory,

As per my knowledge and the release note of Nprinting 17.3,The pivot table is supported in Version 17.3 but

not supported in the previous versions,for more details refer release note of Nprinting 17.3.

Note: If you are currently using NP 17.3 version ,then there is no necessity to create the straight table for getting the data into the Nprinting designer.,You can use the pivot table object created in the QlikSense application.

Re: Getting a Qlik Sense Pivot table in nPrinting

Lech_Miszkiewicz — Mon, 10 Apr 2017 02:11:16 GMT

Hi Ranjit, could you please attach this release note? I went through release notes and did not find anything about pivot tables beeing supported.

thanks

Lech

Re: Getting a Qlik Sense Pivot table in nPrinting

ogster1974 — Mon, 10 Apr 2017 14:39:37 GMT

Hi Rajit

I've revisited this functionality as i'm on 17.3.0 and would love more acces to Piviot tables.

I still cannot bring Piviot tables into an Excel report as a table. Only Straight tables i've been able to include.

However if I want to bring it into my report as an image then the Piviot table object is available and will go in as an Image. This has been there for awhile and ive used for Powerpoint reports.

Regards

Andy

Re: Getting a Qlik Sense Pivot table in nPrinting

Lech_Miszkiewicz — Mon, 10 Apr 2017 23:22:10 GMT

I forgot about Pivot Table supported as an image object - Not great solution though.

Re: Getting a Qlik Sense Pivot table in nPrinting

ian_brooks — Wed, 17 Jan 2018 19:16:15 GMT

Do we know if this functionality will be available in a future release?

Re: Getting a Qlik Sense Pivot table in nPrinting

ogster1974 — Wed, 17 Jan 2018 21:10:56 GMT

The way to go about it is to being the data you want in as a straight table in a seperate sheet and you create the pivot table in excel itself.

Re: Getting a Qlik Sense Pivot table in nPrinting

sam_1919 — Mon, 12 Mar 2018 11:47:28 GMT

Hi gurus,

Is this issue fixed?

Even february 2018 version it is coming as an image.

Is there any other work around for it?

Please let me know if there is any way out.

Thanks and Regards

Saiprasad Ashok More

Re: Getting a Qlik Sense Pivot table in nPrinting

Chanty4u — Mon, 12 Mar 2018 11:51:23 GMT

As andy said - you need to create a stright table in qlik with seperate sheet

and you need to create custom pivot tables then only it will work.

Re: Getting a Qlik Sense Pivot table in nPrinting

sam_1919 — Mon, 12 Mar 2018 12:49:59 GMT

Hi Chanty,

Thank you for your response.
Yeah i agree with Andy.

The table which i want to create is a pivot with

Row: Customergroup

Column: JC code

Measure: Sales in Tons

The intention of having a pivot table in NPrinting is when a new JC code’s data comes up, separate columns gets

added up in Qlik Sense Pivot table.

I want to replicate the same feature in NPrinting Excel.

When a new JC’s data comes let’s say we had data till JC 8 this month, next month JC 9’s data is added in Qlik Sense, a new column is added in Qlik Sense, same should be added automatically in NPrinting.

Whether is there any way to achieve it?

Please let me know.

Thanks

Saiprasad Ashok More

Re: Getting a Qlik Sense Pivot table in nPrinting

Chanty4u — Mon, 12 Mar 2018 13:19:05 GMT

yes it will add.

whenever the data is populated in QLiksense . then after the reload should happen in Qmc

then after you need to reload the metadata in Qlik Nprinitng

if you want to add any new coloumns in Qlik - the should be added in designer aswell.

Re: Getting a Qlik Sense Pivot table in nPrinting

sam_1919 — Tue, 13 Mar 2018 04:41:39 GMT

Hi Chanty,

So it is a manual process of adding columns in designer?

Every time we have to add a column if we follow this method. In that case, it won't make much difference between pivot table properties and a straight table properties.

Is there any way where i just add pivot table ID in NPrinting, and it automatically adds the columns in Excel table when Qlik sense pivot is loaded with a new column?
We don't want to add more manual interventions.

Thanks and Regards
Saiprasad Ashok More

Re: Getting a Qlik Sense Pivot table in nPrinting

Chanty4u — Tue, 13 Mar 2018 06:25:33 GMT

let me clear from my end:

adding data into column? - foe example this month you have 1 filed with 10 rows of data next month it will be 11 rows? - if this means no need to add anything

or you are adding new column in your table? - this means you need to add

Re: Getting a Qlik Sense Pivot table in nPrinting

sam_1919 — Tue, 13 Mar 2018 06:58:03 GMT

I'm talking about column in the table.

If the column is added in the table, same should be reflected here.

E.x. I have Month in the pivot columns from Jan to Dec. and i have data only from Jan to March for now. other columns will be shown blanks or zeros. if April column in qlik sense gets data, even NPrinting should

can we have a table in NPrinting where the column get automatically added when qlik sense pivot gets the column data?

Re: Getting a Qlik Sense Pivot table in nPrinting

Chanty4u — Tue, 13 Mar 2018 08:43:11 GMT

yes.

you can create a custom template for that 12 months by default. so when ever the data fetch it will display the same.

Re: Getting a Qlik Sense Pivot table in nPrinting

sam_1919 — Tue, 13 Mar 2018 09:11:28 GMT

We have dimension with 23 values in it. one pivot table which uses the same dimension has 23 columns data.

To replicate the same in straight table is tedious and clumsy.

Custom template you mean we have to create a straight table for all the 23 columns and then do it?

Re: Getting a Qlik Sense Pivot table in nPrinting

Chanty4u — Tue, 13 Mar 2018 09:17:07 GMT

you can add a stright table in qliksense sheet .

export that into excel.

from that sheet you can create your pivot table how you want and all,.

then delete the base sheet data [it is called template]

same you can import to designer while creating it will ask for custom template

then you can use this and generate the template so it will give you the pivot table result.