NPrinting Excel reports

[ShrutiShinde_]

Hi All,

I am new to NPrinting so please help me in resolving below error

IN Qlik NPrinting when we drag a column to the excel template then after previewing the data comes in a column but my requirement is that I need this data in a row. Like we do the transpose operation in excel while pasting.

EG: IN QS I have a column, when I drag it to Nprinting it comes as

RollNo

1

2

3

But I want this column to be displayed as row

like : RollNo 1 2 3

How can I achieve in Qlik NPrinting itself or any perfect solution with work around

[Chanty4u]

Hi,

why cant you do it  Qlik itself and use that object in  Np? .

[ShrutiShinde_]

I tried with pivot table but did not get the expected result.
Can you tell me how we can do it in QlikSense.

[Chanty4u]

Did you tried with cross load ?

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-c...