topic Re: Levels with Table in Qlik NPrinting

Levels with Table

JustinDallas — Mon, 04 Dec 2017 22:20:11 GMT

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 — Mon, 04 Dec 2017 22:41:35 GMT

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.

Re: Levels with Table

Ruggero_Piccoli — Tue, 05 Dec 2017 09:30:32 GMT

Hi,

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

Best Regards,

Ruggero

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

Re: Levels with Table

JustinDallas — Tue, 05 Dec 2017 14:59:03 GMT

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.

Re: Levels with Table

Anonymous — Wed, 21 Feb 2018 11:56:59 GMT

Hello Justin,

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

Thanks

Re: Levels with Table

JustinDallas — Wed, 21 Feb 2018 17:16:54 GMT

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

Re: Levels with Table

Ruggero_Piccoli — Thu, 22 Feb 2018 09:14:51 GMT

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

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

Re: Levels with Table

berryjulien2 — Sun, 04 Mar 2018 19:52:48 GMT

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 — Mon, 05 Mar 2018 01:35:09 GMT

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

berryjulien2 — Mon, 05 Mar 2018 08:57:17 GMT

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 — Mon, 05 Mar 2018 09:23:24 GMT

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

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

Re: Levels with Table

berryjulien2 — Tue, 06 Mar 2018 13:43:55 GMT

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 — Tue, 06 Mar 2018 14:47:46 GMT

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

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

Re: Levels with Table

berryjulien2 — Wed, 07 Mar 2018 10:47:08 GMT

I deleted the equal sign