topic Re: Layout query - NPrinting in Excel in Qlik NPrinting

Layout query - NPrinting in Excel

Sa_Rah — Fri, 10 Nov 2023 10:57:06 GMT

Hi,

Is it possible to create an NPrinting Excel report with the below layout for each ID? Two fields, Field 9 and Field 10, would need to be situated below the other fields in the same record:

ID	Field 1	Field 2	Field 3	Field 4	Field 5	Field 6	Field 7	Field 8	Description	Discussion
227055	21/09/2023	21/09/2023	Type	Type 1	Site	Location	Area	Reason	Please see below	Please see below
Field 9
Long character field of description
Field 10
Long character field of discussions around event

Thanks

Re: Layout query - NPrinting in Excel

rubenmarin — Fri, 10 Nov 2023 11:05:25 GMT

Hi, yes, you can load data from a simple table, that allows you to use each field as you want, and you might need to uses levels to iterate by each ID.

Re: Layout query - NPrinting in Excel

Sa_Rah — Fri, 10 Nov 2023 15:36:55 GMT

Thank you! (and apologies for the auto solution, it relates to my organisation's email provider)

We have an NPrinting course coming up, and this report is one of the main things I'd like to be able to use NPrinting for to reduce the human hours currently reqd.

Re: Layout query - NPrinting in Excel

Ruggero_Piccoli — Mon, 13 Nov 2023 08:28:28 GMT

Hi @Sa_Rah ,

If you want to read something before the training course, I suggest you to start from https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/Introduction/Get-started.htm

Best Regards,

Ruggero

Re: Layout query - NPrinting in Excel

Sa_Rah — Tue, 28 Nov 2023 14:10:23 GMT

Thanks Ruggero!