you can merge cell in the NPrinting , you need to prepare your chart in the Qlikview and then you the same in the NPrinting .
To achieve the above representation , follow this document
and use the same chart in the NPrinting
It seem like a limitation in NPrinting, if you have limited let of data you can try like this , copy the object as a clipboard object or you need to create a manual Pivot table . Check this
How are you bringing this chart into NPrinting? as an image or as a table.
If you bring it in as an iamge, there is not much you can do in Nprinting - all formatting needs to be done in QlikView
If you bring the object in as a table, then you can move either the entire table as a whole, or column by column, which will allow you to format each cell/column in excel
see attached for reference and further detail
You can also go to the main NPrinting community, Customer Feedback for Vizubi, and search on Excel for additional articles and pointers
I am bringing this as an Table not image.
Anyway for the Merging cell its not possible. For that we need to create Pivot Table in the Excel. So I am going with the same.
But for the 2 point i.e
2. There are some value which is showing in left align of cell as a text in comment even though in Chat Properties-presentation-align I have checked for right (both in Data & Numeric).
I have got the solution and it is in QVW
HELP---About QlikView---Right Click the Qlikview icon which is in down left corner, you get a pop up in that select
ExcelExportMixedAsText mention 0 and then click on Set ---- Save Next Script on Load.
then you will get it.