topic NPrinting - Text Object in Excel Report in Qlik NPrinting

NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 12:22:38 GMT

When placing a TX Object from a dashboard into an Excel Report it appears as this:

Instead of the exact copy of the text object ... is pasting a text object in an excel report possible?

Thanks in advance!

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 14:18:40 GMT

I am not quite sure I understand your question or issue

It sounds like you are bringing a TX object into NPrinting as an image but you do not like the way the iamge shows in the report?

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 16:38:19 GMT

Hi Adam,

The initial questions is: are you able to paste TX objects into excel reports in NPrinting?

When I tried to do this, the text object appears as above which doesn't reflect what the TX object originally contained.

Originally the TX contained text and calculations and I inputted it like this:

Does that explain my issue better?

Thanks!

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 16:47:20 GMT

yes it does - how did you bring the object over in NPrinting - as an image?

If so, what paging, filters, etc are you using? Do you have clear selections set with your connection?

At the time the applciation runs and there are no filters, level, paging, etc that would duplicate the selection process in the applciation, to Nprinting, there is nothing selected

Does that make sense?

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 16:55:01 GMT

I'm not sure I completely understand.

I added the TX as an image , I'm not using any filters, not sure what paging is and the selections are cleared on the connection.

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 16:59:19 GMT

any chance you can post the nsq and qvw file

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 17:04:41 GMT

Not sure that'll be possible

The TX object content looks a bit like this (if that helps):

='TEXT TEXT TEXT

MTD : ' &

Num((count({<Set Analysis>} DISTINCT id)/

count({<lSet Analysis>} DISTINCT id)),'#,##%')

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 17:10:10 GMT

since you cleared selects on your connection, the applciation does not see any selections being made when the report is run - what selections are you expecting to be selected when the report is run?

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 17:18:46 GMT

No selections need to be made selections shouldn't effect the content of the calculation

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 17:38:22 GMT

I am somehwat confused - the sample you have above in the inital post has

Selection Status:

No Selections

This text object appears to be different?

Are you trying to display the value in the text box which from the above example appears at percent?

can you attach a screen print of the actual text box in qlikview and what it looks like when you run the repor

If your issue is how it looks in the tempalte, that is OK (as <TX624> - that is currect - do a preview and see what shows up

Re: NPrinting - Text Object in Excel Report

Wed, 25 Nov 2015 19:00:47 GMT

Nic

any further info

Re: NPrinting - Text Object in Excel Report

Thu, 03 Dec 2015 14:38:03 GMT

Nic

any new inforamtion on this?