Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

New Contributor III

NPrinting Pivot table

I have made a Pivot table in NPrinting version 16, excel report. I am facing a issue with Month Year format in Sub total cell. Its coming in number format Example

Capture.PNG  Capture.PNG

Not sure how to correct this to make the subtotal heading also display in same format as Month year value.

2 Replies
Esteemed Contributor III

Re: NPrinting Pivot table

go to  table show field list

select the measure and clik on it you will see format option there  select that and change it to custom format whatever the way you want.

New Contributor III

Re: NPrinting Pivot table

Thank you Chanty, But the field (MonthYear) values  are coming as customized 'yyyy-mm' but subtotal columns are coming in number format, is it a way or place I can customize the subtotal columns from the field.Capture.PNG