Create multiple columns from rows of data

stanciuc — Fri, 15 Nov 2024 21:14:46 GMT

Hello,

I have a table with 2 column Name and Status(can have x or -).
Printing the table as it is will print 2 columns on several pages. That is not the desiered output format.
I would like the fields to be printed horizontaly and not verticaly.

Example:

Name Status
A X
B X
C -
D X
F -
E -
M -
N X

Expected output:
A X B X C - D X
F - E - M - N X

I'm Using latest NPrinting version. Thank you.

Re: Create multiple columns from rows of data

Ruggero_Piccoli — Wed, 29 Nov 2023 16:07:51 GMT

Hi,

Qlik NPrinting May 2021 SR1 is out of support, so schedule the upgrade to a supported version. In the text you stated that you are using latest that is May 2023 SR2. In this case please use the right label, thanks.

Qlik NPrinting works by column: you place the tag of a table or tag of columns of a table and they are expanded vertically with the data. It is not possible to expand them horizontally.

You could:

- If you are developing an Excel template, add the column tags in an hidden Excel sheet and use Excel features to create a visible sheet with the layout you want. In this case you can use the Excel function =TRANSPOSE(XX:YY)

- create a table in the source app with that layout, refresh the connection cache and import that table

- import the source object in the Cells node then drag and drop each single cell in the final position. This is feasible only if the source object has a limited size because you have to manually manage all cells and it is positional so if you change the order in the source table you have to update the tags in the template according

- if you use VBA macros remember that related code is only copied to the generated reports but never executed

Best Regards,

Ruggero

Re: Create multiple columns from rows of data

stanciuc — Wed, 13 Dec 2023 21:29:54 GMT

Excel function =TRANSPOSE(XX:YY) works.

Thank you!

topic Create multiple columns from rows of data in Qlik NPrinting

Create multiple columns from rows of data

Re: Create multiple columns from rows of data

Re: Create multiple columns from rows of data