topic Re: Repeat Column header in Qlik Nprint 16.3 in Qlik NPrinting

Repeat Column header in Qlik Nprint 16.3

devarasu07 — Tue, 04 Apr 2017 10:45:38 GMT

Hi All,

I've Qlikview Nprint Report with multiple pages (created excel image object) output and it's working fine.

Issue:

Report Column header not repeated when we take printout (Nprint Generated Excel - image object output). how to achieve repeat column header for multiple page. below two are the issues

1 ) Display image as column value based on each article ID -- Nprint (Excel Pivot table report)

2) Column header need to be multiple pages. (i've report which contains 2000 Article with Image and when we take printout of the o/p column header displayed only current page but we need to display column hdeader all report pages)

What i've tried is,

1) try to set below page break option in my Nprint Qlik doc.and re-generation o/p

2) Also try to create Excel report - Data (Pivot table) but unable to display image as column value in Nprint Excel report. (manged to show in qlikview)

below is the expected output. when i tried the same in nprint it shows URL instead of the image.

Do you have any idea/suggestion on this?

Thanks for your time

Regards,

Deva

Re: Repeat Column header in Qlik Nprint 16.3

devarasu07 — Thu, 06 Apr 2017 08:45:09 GMT

Hi @Daniel Jenkins

Do you have any idea how to resolve this issue? please share your valuable suggestion. Thanks

Regards,

Deva

Re: Repeat Column header in Qlik Nprint 16.3

Daniel_Jenkins — Thu, 06 Apr 2017 23:25:31 GMT

Hi Deva,

I showed you in multiple places how this can be done using Bundle load to get images into the QVW. The Excel report template uses a text object as an image and levels:

Flags in Nprinting table objects

Qlikviewlike lmage representation with NPrintin... | Qlik Community

Maybe someone else has a solution but I can not get images to render in an Excel pivot table.

For headers/footers in excel: https://community.qlik.com/thread/237955 - see post timestamp 28/10/2016 2:02 AM

HTH - Daniel.

Re: Repeat Column header in Qlik Nprint 16.3

devarasu07 — Fri, 26 May 2017 04:31:12 GMT

Hi @djk

I've tried your suggestion, Excel report table view with picture as column value option and it's working but have below two issue, can you advise me how can we resolve it? Thanks in advance

1) excel output measure field - shows string instead of Number format (i've tried set custom format like ###0.0 and not working)

2) Export nprint excel output - Article picture shows too small, blurred, resolution not good. i've tried to re-size via don't fit, adjusted the width and height etc)

Kindly share your valuable input.

Regards,

Deva

Re: Repeat Column header in Qlik Nprint 16.3

Daniel_Jenkins — Fri, 26 May 2017 05:16:55 GMT

Hi Deva,

1. Qty & Stock should have Number Format Settings set to Number. Reload.

2. Increase the size of your Text object TX02 to the desired size

HTH - Daniel.

Re: Repeat Column header in Qlik Nprint 16.3

devarasu07 — Fri, 26 May 2017 06:30:16 GMT

Hi @djk

I've tried your suggestion, now it's shows clear picture but width and height are got issue and picture got overlapped with other column value can you advise me.

Re: Repeat Column header in Qlik Nprint 16.3

Daniel_Jenkins — Fri, 26 May 2017 07:01:48 GMT

Hi Deva,

You need to make adjustments and keep trying. Here is one option:

HTH - Daniel.

Re: Repeat Column header in Qlik Nprint 16.3

devarasu07 — Fri, 26 May 2017 07:10:34 GMT

Hi Daniel,

Ok sure, i too tried similar setting but my out not shows like yours. could you share your output. Thanks,

Re: Repeat Column header in Qlik Nprint 16.3

Daniel_Jenkins — Fri, 26 May 2017 07:18:39 GMT

Hi Deva,

Here is the project.

HTH - Daniel.

Re: Repeat Column header in Qlik Nprint 16.3

devarasu07 — Fri, 26 May 2017 08:29:13 GMT

Hi @djk

Thanks, the table view - with picture option working fine. tried with pivot table option using existing table design and picture not showing. is there any tool limitation ? kindly advise. Thanks

Re: Repeat Column header in Qlik Nprint 16.3

Daniel_Jenkins — Fri, 26 May 2017 08:51:05 GMT

Hi Deva,

Please re-read my very first reply to you in this thread.

- Daniel.

Re: Repeat Column header in Qlik Nprint 16.3

devarasu07 — Fri, 26 May 2017 09:05:10 GMT

Hi Daniel,

Yeah, gone through your previous reply and reference link. pivot table with column value as picture option is out of box?.