13 Replies Latest reply: Mar 7, 2018 3:45 AM by Ruggero Piccoli RSS

    Nprinting PixelPerfect unexpected filter behaviour

    Jose Escayola

      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.

        • Re: Nprinting PixelPerfect unexpected filter behaviour
          Daniel Jenkins

          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.

          • Re: Nprinting PixelPerfect unexpected filter behaviour
            Ruggero Piccoli

            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-Reports.htm

             

            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.

              • Re: Nprinting PixelPerfect unexpected filter behaviour
                Jose Escayola

                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

                  • Re: Nprinting PixelPerfect unexpected filter behaviour
                    Ruggero Piccoli

                    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.

                      • Re: Nprinting PixelPerfect unexpected filter behaviour
                        Jose Escayola

                        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?

                          • Re: Nprinting PixelPerfect unexpected filter behaviour
                            Ruggero Piccoli

                            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.htm

                             

                             

                            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 PixelPerfect unexpected filter behaviour
                                Jose Escayola

                                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.

                                • Re: Nprinting PixelPerfect unexpected filter behaviour
                                  Jose Escayola

                                  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