Levels with Table

[JustinDallas]

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.

[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:

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.

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

[JustinDallas]

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.

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

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

Version Info:

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

[Anonymous]

Hello Justin,

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

Thanks

[JustinDallas]

No.  I never found a solution to replicating what I saw in the tutorial.

[Ruggero_Piccoli]

Hi,

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

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.

[berryjulien2]

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     

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

[berryjulien2]

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?