Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Evgeniya
Contributor III
Contributor III

Orientation of field in excel report in NPrinting

Hello. I have stright table. I use only one field from this stright table. I would like change vertical orientation of field to horizontal orientation. How can I realised this case? I neet only one field and I can not use pivot table(((

1 Solution

Accepted Solutions
Andrea_Ghirardello

I'm afraid that there are not so many alternatives.

I see only two:

1- Use the straight differently in QlikView by

a. configure sort for the dimension you have to use as you prefer

b. hide any other expression ("hide column" check in the presentation tab) and remove totals ("Total mode" in Expression tab)

c. enable "Horizontal" check in the presentation tab

d. use the chart as image in the NP Template. You cannot use the column as a table column since the export from QlikView doesn't maintain the horizontal property when exporting.

2- ONLY IF THE AMOUNT OF VALUES TO EXPORT IS KNOWN: extract the column values exploiting the Cell feature in the NP template. In this way you will be able to place the single tags horizontally.

Hope this helps.

Andrea

View solution in original post

4 Replies
prma7799
Master III
Master III

djkaig‌  will help you on this...

Andrea_Ghirardello

I'm afraid that there are not so many alternatives.

I see only two:

1- Use the straight differently in QlikView by

a. configure sort for the dimension you have to use as you prefer

b. hide any other expression ("hide column" check in the presentation tab) and remove totals ("Total mode" in Expression tab)

c. enable "Horizontal" check in the presentation tab

d. use the chart as image in the NP Template. You cannot use the column as a table column since the export from QlikView doesn't maintain the horizontal property when exporting.

2- ONLY IF THE AMOUNT OF VALUES TO EXPORT IS KNOWN: extract the column values exploiting the Cell feature in the NP template. In this way you will be able to place the single tags horizontally.

Hope this helps.

Andrea

Evgeniya
Contributor III
Contributor III
Author

Thank you. I think I will use second way

Andrea_Ghirardello

In that case, if it helps, here is a tutorial that explains how to use cells:

Selected QlikView Cell Values Used in Excel Reports

Br,

Andrea