Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
escayolaj
Partner - Contributor III
Partner - Contributor III

Nprinting PixelPerfect unexpected filter behaviour

I am using Nprinting 17 (February 18 version) with a QlikSense connection.

I have created a very simple app with a very simple table as such:

test_app.PNG

In Nprinting I have created a report with the table above imported as level and added in a detail report:

template_test.PNG

Then I applied the following filter:

test_filter.PNG

Assuming that filters in Nprinting work as filters in QlikSense (selections), I would expect the outcome to be similar to the first screenshot due to the set analysis of the second expression. However, the outcome is:

test_report.PNG

Am I missing something? Is this behavior intended? Is this a bug?

Has someone else experienced this?

It looks to me like a very noticeable bug.

Thank you for your help.

1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

Hi Jose,

This works fine in other report types that I tried - the issue is manifest with PixelPerfect only (as far as I can tell). Not sure if it is because of the Levels & detail report created in PixelPerfect that is not required in other formats.

Here is a test result with HTML (I added a formula to display current selections on Dim1 - GetFieldSelections(Dim1) - this too does not evaluate in PixelPerfect).

This could be a limitation in PixelPerfect because of the different way reports are created. I suggest you open a case with Support so it can be investigated further.

HTH - Daniel.

View solution in original post

13 Replies
Daniel_Jenkins
Specialist III
Specialist III

Hi Jose,

Looks like it's working as expected. What do you get if you select Dim1 value A in the Qlik Sense App? Your filter should simulate that selection.

Edit: I see you have that selection already. What happens if you select A in the table in Qlik Sense? Can you share a copy of your app?

- Daniel.

escayolaj
Partner - Contributor III
Partner - Contributor III
Author

What do you mean select A in the table? It's already selected in the first screenshot of the above post.

Open a new app load editor and press ctrl+0+0 and you will get the same app as I used in the example. You can easily create the same table.

Ruggero_Piccoli
Support
Support

Hi,

It is correct. In the template you created a table only with rows. If you want headers and totals you must add them in the template as explained in the help site. The same for the cell formats, for example you can add borders in the template settings.

Refer to:

- https://www.youtube.com/watch?v=-o8KwwYMVq8

- https://help.qlik.com/en-US/nprinting/February2018/Content/PixelPerfectReports/Intro-PixelPerfect-Re...

An alternative could be to add the Sense object as an image.

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
escayolaj
Partner - Contributor III
Partner - Contributor III
Author

Hi Ruggero,

Thank you for your reply.

I am not refering to the totals or formatting, I am referring to the rows displayed in nprinting. The second expression in my source table has a set identifier {1} so when Nprinting imports the table, it shold import all rows (Dim1= A , B and C ) even if I have applied a filter in Dim1=A.

It looks like Nprinting disregards the set identifier and forces Dim1 to only have one value, while according to the set identifier, the table should display ALL values of Dim1 despite the Nprinting filter (which I assume works as a selection).

Kind regards,

Jose

Ruggero_Piccoli
Support
Support

As Daniel suggested, if you apply the same filter in Qlik Sense what do you will see?

In Qlik NPrinting you'll see the same result.

In the case that we can see in the screenshots you created and apply a filter with Dim1=A. Is link to click in the A value of the Dim1 column in Sense. Only the rows with value A will be displayed.

It is working as expected.

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
escayolaj
Partner - Contributor III
Partner - Contributor III
Author

Please notice that in the first screenshot, selection on "A" is made over Dim1. Note as well that the table shows all values of Dim1 due to the set identifier in the second expression ({1}).

If Nprinting filters work as selections, I would expect that the Nprinting report displays also ALL values of Dim1 in the table, again due to the set identifier.

Can you please clarify how filter work in Nprinting? Are they supposed to be the same as QlikSense filters? Or should they work as Where clauses in the source data?

Ruggero_Piccoli
Support
Support

Qlik NPrinting filters work as Qlik Sense filters. As when in Sense or in QlikView you select some values of a column you see only the rows with that values. Qlik NPrinting does the same actions that you can do manually.

Filters are not set analysis. They are different things.

If you want to see all rows with set analysis remove the filter.

About Qlik NPrinting filters refer to https://help.qlik.com/en-US/nprinting/February2018/Content/ReportsDevelopment/Static-dynamic-filters...

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.



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
escayolaj
Partner - Contributor III
Partner - Contributor III
Author

Qlik NPrinting filters work as Qlik Sense filters. As when in Sense or in QlikView you select some values of a column you see only the rows with that values. Qlik NPrinting does the same actions that you can do manually.


Please review carefully the series of screenshots I posted.

1. I created a table in QlikSense with an expression using {1} as set identifier. This means the expression will disregard all selections. Therefore when I apply a selection on "A" over Dim1, still all values of Dim1 appear in the first column of the table (see first screenshot).

2. I imported the same table as level in a pixelperfect report. This means that all rows of the QLikSense table should be displayed according to the filters applied in Nprinting.

3. I apply a filter in Nprinting as Dim1 = A. Note that this is exactly the same selection I made on the app where all rows were showing in the table due to the set identifier.

4. The resulting report only contains the "A" row. According to your last reply, if Nprinting filters work exactly as selections in QlikSense, all rows should appear as they do in the QlikSense app when applying the same selecition.

escayolaj
Partner - Contributor III
Partner - Contributor III
Author

Hi Ruggero,

I would like to know if you have understood the issue I was trying to expose here. If yes, I would like to know if you are looking into this.

Thank you in advance,

Jose