13 Replies Latest reply: Mar 7, 2018 5:47 AM by Julien Berry RSS

    Levels with Table

    Justin Dallas

      Hello Folks,

       

      After sitting through the wonderful tutorials set found here (Working with Qlik NPrinting PixelPerfect reports) I've tried to create my own "Table through Levels" to no avail.  During the tutorial, we hear the tutorializer reference I believe "Sales vs Margin by Sales Rep".  In the Executive Dashboard, this is a Scatter Plot. 

       

      I tried to repeat this with a straight table, but I don't see my table being listed in the "Add Fields" selection. The only items I see are F\*, and not O\*.

       

      What concept about adding a table to a Detail Report band am I missing?  Any help is greatly appreciated.

        • Re: Levels with Table
          Lech Miszkiewicz

          Did you use native straight table, or maybe an extension.

           

          To see object names instead of F\* O\* you need to provide Caption name  here in Qlik Sense object you want to refer to:

           

          1.png

           

          cheers

          Lech

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

          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: Levels with Table
            Ruggero Piccoli

            Hi,

             

            Did you refreshed the Qlik NPrintinng cache after adding the straight table in the Qlik Sense app?

             

            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: Levels with Table
                Justin Dallas

                Hello Folks,

                 

                I'm back in work, and I've verified and tried the given suggestions to no avail.

                 

                1. The table has a caption, and it's a standard Straight table extension-free.

                 

                NPrintingTable-1.PNG

                NPrintingTable.PNG

                 

                2. The cache has been refreshed, as that is my go-to "make-the-problem-go-away" method

                3. I can't find my table in the Add levels dialog

                NPrintingTable2.PNG

                4. But I can find it in the Table > Add objects dialog

                NPrintingTable3.PNG

                 

                Version Info:

                QSNPrinting.PNG

                NPrinting.PNG

                 

                Let me know if you all have any other ideas that I could try, and thanks a lot for yalls help.

                  • Re: Levels with Table
                    Gajendra Singh

                    Hello Justin,

                     

                    Were you able to find the root cause or fix? I am facing the same issue.

                     

                    Thanks

                    • Re: Levels with Table
                      Ruggero Piccoli

                      Hi,

                       

                      Qlik Sense straight tables can be added to the Qlik NPrinting Levels node.

                      Sense Straigh Tables in Levels.png

                       

                      Please tell us how is build your straight table, what kind of fields it contains. You could also try to leave in the straight table only the columns that are fields calculated in the reload script, refresh the cache and try again. I suspect that in your table there are calculated fields or something else that made the table not visible in the Levels node.

                       

                       

                      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: Levels with Table
                          Julien Berry

                          Hello,

                           

                          I have this kind of issue.

                          Is there any restriction on the object (table, straight table) or on the number of dimensions, measures?

                          Thanks in advance for your return

                          Best regards     

                            • Re: Levels with Table
                              Lech Miszkiewicz

                              First thing you want to check is if you have any calculated dimensions? 

                              They will not work.

                               

                              You simply want a field straight from data model in your dimensions for table used in levels.

                                • Re: Levels with Table
                                  Julien Berry

                                  Thanks for your answer, I am using QlikSense.

                                  I will check if I have any calculated dimensions.

                                  Could we also use a simple table in a level?

                                    • Re: Levels with Table
                                      Ruggero Piccoli

                                      Yes, simple straight tables can be added in Levels. In this case you'll have a row in the level for each row of the table.

                                       

                                       

                                      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: Levels with Table
                                          Julien Berry

                                          Once again, could you tell me with a straight table if there is any constraint like a calculated dimension.

                                          I have some straight table unavailable as a level.


                                          Thanks in advance for your answer    

                                            • Re: Levels with Table
                                              Ruggero Piccoli

                                              Hi,

                                               

                                              If you cannot see a specific straight table in the Levels node it means that the table is not suitable to be added. For example it has calculated dimensions.

                                              Use only simple fields and the straight table should be visible.

                                               

                                               

                                              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.