topic Re: Nprinting - no data in reports in Qlik NPrinting

Nprinting - no data in reports

harjedalskok — Mon, 30 Oct 2017 14:02:47 GMT

Hi today I finnaly i got everything to work with the installation av Nprinting, well i think.

When i use the example file from QLik, "sales demo" and create a report using the nprinting designer, and then publish it it shows data in tables ive selected in the report.

But when im trying to do same with our documents, meaning when ive made a conenction to our documents which it says are succesful, "cache generated".

Creating the report works, but when i preview it, it only shows the dimension and the name of the xpressions.

Is there anybody that can enlight me in this matter, feels that it is something really easy to fix but i dont seem to find how.

Thx in advance.

ive attached a test result from the export of the report.

Re: Nprinting - no data in reports

cristinapo — Mon, 30 Oct 2017 14:39:57 GMT

Hi,

In the NPrinting template, when you actually try to bring the objects in the report, does the connection to your document appear in the list. And if so, are the listed objects the same you find in your Qlik qvw file?

It would help if you attached some screenshots from the template - like when you go to add objects, when you select the connection, the list of objects detected in that connection, also a screenshot of the template itself etc.

Thanks,

Cristina

Re: Nprinting - no data in reports

harjedalskok — Mon, 30 Oct 2017 15:14:38 GMT

Hi Cristina,

Thx for your answer.

Yes the objects are appearing in the Nprinting Designer, and I can see that its fetching the right connection.

Ive attache ss to the primary question above.

Re: Nprinting - no data in reports

cristinapo — Mon, 30 Oct 2017 15:39:26 GMT

A shot in the dark, are you sure you actually have values in your chart? Like to check if you don't have null values, which would explain the "-" values in the excel report.

Re: Nprinting - no data in reports

harjedalskok — Mon, 30 Oct 2017 15:42:36 GMT

Yes there are values, this is active central document.

Re: Nprinting - no data in reports

Ruggero_Piccoli — Tue, 31 Oct 2017 10:48:08 GMT

Did you applied some report filters?

The reports seems correct, the template has one table and one column and they are correctly filled (the column has the months for example) but hte final result indicates an empty original table.

So it could be that you applied some filters on the report that empty the table before to export it.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Nprinting - no data in reports

harjedalskok — Tue, 31 Oct 2017 11:18:41 GMT

there are no reports filters, ive double checked now. That was one of my first conclusion. But it happens not only with this documents but with all test i do, using connections to other documents.

But when i use a conncetion to "sales demo" in the same report it gives results on the "sales demo" tables.

Feels realy weird this, as it is some setting i need to do in qlikview desktop.

Re: Nprinting - no data in reports

Ruggero_Piccoli — Tue, 31 Oct 2017 11:22:08 GMT

Does your document use section access?

Can you try with another .qvw?

Re: Nprinting - no data in reports

harjedalskok — Tue, 31 Oct 2017 11:25:10 GMT

Hi again, and thx for trying to help me.

Ive tried to create connections to diffrent qvw documents, with same result. No we dont use section acces in none of our documents.

But as i wrote before, when i the connection to "sales demo" it works, so it must be something with all our documents.

Re: Nprinting - no data in reports

Ruggero_Piccoli — Tue, 31 Oct 2017 11:33:31 GMT

There is something that is filtering the data from your documents. The report is created correctly because you see the first column filled and headers and you have not errors. So we need to investigate why your document are filtered.

Is Sales Demo a local document and your documents connected from a server? Very the user who is running the Qlik NPrinting Enginse Windows service.

If this does not resolve I suggest you to open a support ticket so my colleague can organize a remote connection with you and investigate while seeing your environment. If you do so please remember to share here the answer so it can help other people.

Best Regards,

Ruggero

---------------------------------------------

Re: Nprinting - no data in reports

harjedalskok — Tue, 31 Oct 2017 12:02:29 GMT

Ive investigated a bit more and found out that, this documents that ive tried has selections that cant be null,

It seems that Nprinting, dont make a selection even if the listbox has "need to have value" selected.

Can we in Nprinting set selections?

Ive now rewrote some of the expression so they make there on selections if none is made.

And now i got it to work

Re: Nprinting - no data in reports

Ruggero_Piccoli — Tue, 31 Oct 2017 14:09:45 GMT

You can create Filters Static and dynamic filters ‒ Qlik NPrinting

and associate them with Users, Tasks, Reports or Objects.

Best Regards,

Ruggero

---------------------------------------------

Re: Nprinting - no data in reports

harjedalskok — Tue, 31 Oct 2017 14:18:24 GMT

Thx alot, that will make it easier.

I will start to create a Salesrapport,

Where the objective is as follow.

The salesrepresant will get a report "salesreport" every month, lets for say the 5 in everymonth.
The salesrepresant will be able to login to "newstand" and check the report.

The tricky part, for me as a newbie, is to create a filter that:

Make the "salesman" selection when sending the report to specific salesman.
When that specific salesman log into newstand he should only see his sales.

The only selection / report that will be needed is to select "salesman" in the qvw document.

How do I associated the "nprinting recipient with the selection "salesman".

I should probably start a new Discussion, but I start here.

Re: Nprinting - no data in reports

Ruggero_Piccoli — Tue, 31 Oct 2017 14:42:40 GMT

I would to suggest you to read the help site and related intro videos, because they explain exactly what you want to have:

create a filter for each salesman
create a user for each salesman
associate the filter with the user
create a report template
create a task that generate that report filtered for each user and sent it to all your salesman filtered via mail or on the NewsStand

http://help.qlik.com/en-US/nprinting/September2017/Content/Videos/Intro-Videos.htm

Best Regards,

Ruggero

---------------------------------------------

Re: Nprinting - no data in reports

harjedalskok — Tue, 31 Oct 2017 14:51:33 GMT

Thank you, Im started to create the import file for all users. 200+.

If im gonna need to create one filter for each user dont get how that will work,

im looking more for a filter that says, if the salesman is test.testsson then filter out "salesman" test testsson and send to test.testsson@test.com

and when test.testsson@test.com logg into "newstand" the report would filter out the test.testsson results.

I found a nice import template, where i can set all filters directly, so its not much work. anyway, again, thanks alot for all the pointing in the right direction.

Re: Nprinting - no data in reports

srilakshmi_as — Tue, 14 May 2019 12:57:55 GMT

Replying here ,for the sake of others ,if anyone experienced this issue.

For me it happened that, I have added cycle field which has null value for the specific filter and then report is not getting generated.So i have to create a separate report for this kind of new filter requirement.So we need to have an eye on Dynamic Report name,Cycle etc fields .

Re: Nprinting - no data in reports

Ragnar — Tue, 15 Feb 2022 13:16:08 GMT

Yo Ruggero,

Thanks for the advice of the filters may be excluding the data before its exported even though its 'there' in Qliksense.

Had a similar issue whereby the values weren't pulling through and that was because of a filter being applied. This I checked after reading your possible cause which was the solution.

Legend.