topic Re: Images by filter not working in NPrinting in Qlik NPrinting

Images by filter not working in NPrinting

millymac — Thu, 20 Feb 2020 15:28:02 GMT

Afternoon all,

Has anyone come across an issue when using an image on Nprinting 19 (Nov 19). I have a bar chart and a pie chart and some tables that filters by an user to create stats by each user it currently returns the correct figures for the tables but when it comes to the Image it outputs the total figure on the bar chart and pie chart. just to note this is an excel output with a tab per user.

This is an old report that I have been running on Nprint 16 for years. I am currently migrating all reporting from 16 to 19 with no issues unless there is an image in the output as it will not filter by whatever is required.

I have a number of these type to move but I need to resolve the image problem. I could be missing something with the new NPrinting I understand that is different to 16.

Hopefully somebody has come across this and can offer some help.

Thanks

Re: Images by filter not working in NPrinting

Ruggero_Piccoli — Thu, 20 Feb 2020 15:44:29 GMT

Hi,

I'm sorry but I have not understood the issue. Could you add some screenshots of the template and output you get?

How are you migrating from 16 to 19? If you are using the migration tool, have you some error messages?

I'm not aware of any kind of problem in filtering images. Check if the original 16 template has object filters that are not copied into the 19.

Did the 16 version used some entities like linked fields that are unsupported by the 19?

Best Regards,

Ruggero

Re: Images by filter not working in NPrinting

Lech_Miszkiewicz — Thu, 20 Feb 2020 23:29:32 GMT

Agree with Ruggero,

It is likely you use unsupported filters on those objects,

You need to be aware and understand what you are doing when proceeding with migration. Did you check all reports, filters etc... before proceeding?

Have you checked for all supported / not supported objects in projects you are migrating? Filters using lock/unlock if locked, clear all... bookmark, linked fields..etc...

Re: Images by filter not working in NPrinting

millymac — Thu, 27 Feb 2020 14:02:01 GMT

Thanks for you comments, I completed a basic template to show what I am trying to do (see attached output)

I have a pool of data which I want to return results by owner, I have created this on Nprinting using an image and a table

Line chart is returning total figure and the table is returning the correct figures by owner.

There are no errors as I created this new within Nprinting, I have looked at and read a few different tutorials and cannot figure out what I am missing or if I am missing something.

On the chart I am using below to apply the name of the owner on the output = if(GetSelectedCount(Owner)>1 or GetSelectedCount(Owner)=0,'Vulnerability Total Trend - All Owners', 'Vulnerability Total Trend - ' &Owner)

Re: Images by filter not working in NPrinting

millymac — Thu, 27 Feb 2020 14:11:21 GMT

Also a snapshot of the Nprinting Template editor for this query

Re: Images by filter not working in NPrinting

Ruggero_Piccoli — Mon, 02 Mar 2020 15:34:16 GMT

Hi,

So the issue is that the image is not filtered according to the page value?

Is this happening with NP16 or 19?

Everything in a worksheet generated from a Page is filtered by the page values, images and tables. I tested in my installation and it is working correctly.

If you want the image unfiltered you need to place it in a worksheet different than the one with the page.

Best Regards,

Ruggero

Re: Images by filter not working in NPrinting

Lech_Miszkiewicz — Mon, 02 Mar 2020 21:08:23 GMT

....and you are sure you are not using 2 difference connections for those objects accidentally?

Indeed it looks strange - I have never come across issue like this before.

Re: Images by filter not working in NPrinting

millymac — Thu, 05 Mar 2020 13:40:05 GMT

Update on this

What I have discovered that if there is a sheet event trigger on a sheet this will not return the correct results required I have a date trigger on one sheet with a clear all on the leave sheet, when I removed the triggers it resolved itself however the qlikview application requires sheet triggers for users viewing the application I have a work around for this one by having a separate application for Nprinting I have a number off larger ones that I now need to do.

I am really missing having the application open while running out Nprinting and seeing what it is doing.

Re: Images by filter not working in NPrinting

Ruggero_Piccoli — Thu, 05 Mar 2020 14:02:29 GMT

Hi,

Triggers are not supported by both QlikView NPrinting 16 (and older versions) and Qlik NPrinting 17+.

Best Regards,

Ruggero