topic Re: Unreadable Content Error in NPrinting Excel Report in Qlik NPrinting

Unreadable Content Error in NPrinting Excel Report

Mon, 25 Apr 2016 05:08:29 GMT

Hi Guys,

Background

I have created an Excel Report
Which contains 2 QVW Table Objects

Application Overview

I have dragged and dropped individual fields from Table Object into the excel columns
To created EXCEL TABLE.. so the end user can sort it and filter it.

The Report task works fine.. However.. when I open the excel report then it first shows me following error

When I click 'NO' then Excel closes down

When I click 'YES' then it opens the file but one table is missing and following shows up.

Any idea on why this would happen ?

Thank you

Re: Unreadable Content Error in NPrinting Excel Report

avinashelite — Mon, 25 Apr 2016 07:24:15 GMT

Have you manually build the column Total reimbursment?? if so then if the number of columns increase then dynamically the position if the Total column will also change so excel will not be able to identify the new column reference then it will show this message

Re: Unreadable Content Error in NPrinting Excel Report

Mon, 25 Apr 2016 07:29:22 GMT

The total Reimbursement row is an excel SUM forumla to provide total. What would be the Alternative.

Re: Unreadable Content Error in NPrinting Excel Report

avinashelite — Mon, 25 Apr 2016 07:46:16 GMT

You can add the total column in the QV itself write ?? or else build the complete table in excel instead of the QV

Re: Unreadable Content Error in NPrinting Excel Report

Mon, 25 Apr 2016 07:57:35 GMT

Hi Avinash,

What do you mean by build complete table in nPrinting?

I have created the table in QlikView and then dragged and dropped individual field into excel because the end report should be an Excel Table so the user can sort and filter it