topic Re: Adjust pivot table format in NPrinting in Qlik NPrinting

Adjust pivot table format in NPrinting

WorkFish — Wed, 29 Jun 2022 09:39:39 GMT

I created a pivot table in qvw and set the centered alignmen,in qvw it works but i use html in nprinting it doesn't work.

It turns out the original format :text type to the left ,numeric type to the right.

How can i set the format as sams as in the qvw?

Re: Adjust pivot table format in NPrinting

Lech_Miszkiewicz — Wed, 29 Jun 2022 10:47:59 GMT

Hi it is not clear what you have done - please provide details and steps (detailed instructions on what you do with screenshots) so we can understand, replicated your issue and provide you with guidance.

Also please provide exact versions of software you are using down to SR level.

You may need to provide a screenshot of your template too (including tag properties) so we can understand what properties you are using there.

You mentioned that you are using HTML template so it is hard to understand how you create pivot table in HTML (image or some other method)

I wrote about building HTML pivot table in this blog post - https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting/ - principles are the same for QlikView as for Qlik Sense

cheers

Re: Adjust pivot table format in NPrinting

WorkFish — Wed, 29 Jun 2022 11:18:43 GMT

HI @Lech_Miszkiewicz

sorry that i didn't explain situation clearly.

the first picture is in qvw that i set value with center align .

second picture is on nprinting

third picture is preview，text alignment is different from the first one,i want them all centered .Do u konw how to adjust it?

Re: Adjust pivot table format in NPrinting

Saurabh_K14999 — Fri, 22 Jul 2022 06:03:30 GMT

Hi,

Try using center alignment in HTML for fields or for object id.

Hope it will work.

Best Regards,

Saurabh.

Re: Adjust pivot table format in NPrinting

David_Friend — Thu, 18 Aug 2022 18:20:02 GMT

@WorkFish did the post from @Saurabh_K14999 help you? if so click the 'accept as solution' thanks!