topic Re: Straight Table Export to Excel with Nprinting ( Transposing Column ) in Qlik NPrinting

Straight Table Export to Excel with Nprinting ( Transposing Column )

elalaoui_sara — Mon, 10 Apr 2017 15:01:08 GMT

Hello

I have the below object on my .qvw :

I need to export thin Object into Excel using Nprinting . I have added the Chart as Table to Excel template , when I run the Task the Object looks like below in Excel :

I need to have the exact Chart in My Excel Report as the qlikView application ( A, B , C , D Columns in Horizontal instead of Vertical). could someone help me please? Thank you in Advance

Re: Straight Table Export to Excel with Nprinting ( Transposing Column )

Lech_Miszkiewicz — Mon, 10 Apr 2017 23:30:51 GMT

The answer is following:

You need to build another object and make sure that under Properties --> Horizonatal (Checkbox) is unchecked. Currently you have a straight table - transposed within QlikView. This transponse function is not carried to NPrinting and it won't be.

You will have to develop different chart - i think pivot table - to achieve what you are trying to do.

This is normal NPrinting behaviour that it reads dimensions and measures and it pulls it accross. In your chart A,B,C..etc are your measures and Mois is your Dimension. You need to change this to ABC... beeing your dimension,Dates beeing your dimension in columns and numbers beeing single measure.

That is what i would do.

regards

Lech

Re: Straight Table Export to Excel with Nprinting ( Transposing Column )

elintham — Tue, 25 Feb 2020 09:26:28 GMT

Hi, Is there any solution for this in Qlik Sense NPrinting? We would like to have the horizontal output.

Re: Straight Table Export to Excel with Nprinting ( Transposing Column )

Ruggero_Piccoli — Tue, 25 Feb 2020 09:42:20 GMT

Hi,

Qlik NPrinting cannot transpose a matrix by itself. If you have a Qlik Sense table (or a QlikView one) organized by column you could:

- clone and organize the new one by rows by using Qlik Sense or QlikView features. Remember to refresh the cache when done before using the new object in Qlik NPrinting. Also remember to close and reopen the Qlik NPrinting Designer because it reads the cache on opening

- Qlik NPrinting starting from September 2018 supporte Excel files with macros (.xlsm). You can add a macro in the report template and generate reports in .xlsm format. Please note that Qlik NPrinting never runs the macros code, it is just copied from the template to the reports. The recipients need to run the macros or you can trigger it on report opening.

Best Regards,

Ruggero

Re: Straight Table Export to Excel with Nprinting ( Transposing Column )

elintham — Wed, 26 Feb 2020 01:49:56 GMT

Hi,

We are using Qlik Sense Web version with Qlik NPrinting April 2019 version.

Do you have any sample macros to work around that? If so, could you please share as we are having difficulties coming up with the template that we need.

This is the question I posted on the community. If you could let us know if that could be achieved using macro, and how to go about it, that would be greatly appreciated. Thanks!

https://community.qlik.com/t5/New-to-Qlik-Sense/Transpose-columns-from-a-straight-table-amp-release-through/m-p/1678833/highlight/true#M158676

Re: Straight Table Export to Excel with Nprinting ( Transposing Column )

Ruggero_Piccoli — Wed, 26 Feb 2020 09:26:01 GMT

Hi,

I'm sorry but in general we do not supply support on developing with third party tools. I suggest you to search on the web. I just check and it seems a common problem so there are many articles about it with VBA code.

Best Regards,

Ruggero