topic Re: Qlik Nprinting Levels in Qlik NPrinting

Qlik Nprinting Levels

subash29 — Fri, 20 Jul 2018 11:55:29 GMT

Hi,

I am using Printing 18.0.1 version in designer and server.I need to create table details in Nprinting which same as my Qlik Sense App (3+ version).I cant get the completed table data in NPrinting in details level.When i am checked in community We need to add the object levels for getting detail reports.

NPrinting 17 - pixel perfect levels

but in my designer i try to search the table objects in Levels .There is no object is showing me.but those objects i can add in Table objects.

Please help me is there any bug present in my tool for not showing the tables objects in Levels.

Re: Qlik Nprinting Levels

arvind_patil — Fri, 20 Jul 2018 12:21:06 GMT

Hi subhash,

Kindly Drag added obejct into Pixel perfect are then Clik on preview. you will get it.

Thanks,

Arvind Patil

Re: Qlik Nprinting Levels

Daniel_Jenkins — Sun, 22 Jul 2018 23:17:48 GMT

Hi Subsh,

You need to add your table as a level and then insert that level into the report as a Detail Report. Follow this tutorial replacing CH184 with your table (BXNmuz):

https://help.qlik.com/en-US/nprinting/June2018/Content/PixelPerfectReports/Simple-PP-Report.htm

The tutorial uses a QlikView connection but it works the same for Qlik Sense.

HTH - Daniel.

Re: Qlik Nprinting Levels

Lech_Miszkiewicz — Mon, 23 Jul 2018 01:05:00 GMT

From What i see Subsh tried to add it as a level but look like this object is not available under level nodes for some reason.

What is your Table object? Is it straight Table? (not pivot??)

Also does it have any calculated dimensions?

cheers

Lech

Re: Qlik Nprinting Levels

subash29 — Mon, 23 Jul 2018 12:23:24 GMT

Yes Lech.you got my point Thanks lot.

The Objects are not available in adding level Search and i am using the straight Table only .It has some calculated dimensions also tool

Re: Qlik Nprinting Levels

Lech_Miszkiewicz — Tue, 24 Jul 2018 00:09:06 GMT

cool.

can you try creating a straight table without calculated dimensions but only with the dimensions coming directly form fields and measures and let us know how it goes.

Calculated dimensions can screw the way level is working.

cheers

Lech

Re: Qlik Nprinting Levels

Ruggero_Piccoli — Tue, 24 Jul 2018 10:50:16 GMT

Hi,

General rule:

- QlikView and Qlik Sense Pivot tables cannot be added to the Levels node

- QlikView straight tables with calculated dimensions can be added to the Levels node

- Qlik Sense straight tables with calculated dimensions can not be added to the Levels node

- When you try to add a QlikView or Qlik Sense object into a node and you cannot see it in the list it means that its type is not supported for the node

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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: Qlik Nprinting Levels

Lech_Miszkiewicz — Tue, 24 Jul 2018 10:55:46 GMT

Ruggero, rpc‌

I would suggest adding some of this information to help.qlik.com as it is not fully there yet. It would be then rock-solid knowledge

currently this is what i found:

https://help.qlik.com/en-US/nprinting/June2018/Content/ExcelReports/More-Levels-Excel-Reports.htm‌

cheers

Lech

Re: Qlik Nprinting Levels

Ruggero_Piccoli — Tue, 24 Jul 2018 12:34:16 GMT

I agree with you and I sent the suggestion 🙂

Re: Qlik Nprinting Levels

subash29 — Tue, 24 Jul 2018 12:52:16 GMT

Hi Lech,

When i am using the straight table with some direct Dimension Fields and Some summation values.

eg: Year, Company, Region, Sum(Revenue).

It must to use the some measure values. Still i am not found the objects in Levels.

Re: Qlik Nprinting Levels

Lech_Miszkiewicz — Tue, 24 Jul 2018 23:28:47 GMT

I run out of options.

Well - there is one more thing as you just mentioned it vaguely - What version of Qlik Sense (Version ad release) are you using. Is it supported with the NPrinitng version?

If you ticked all the boxes and it still does not show up i suggest you open a support ticket with Qlik so they can arrange a conference call and look at your environment.

Once you figure out what was causing the issue please provide us an answer here as well - if you could. thanks Lech

Re: Qlik Nprinting Levels

subash29 — Wed, 25 Jul 2018 07:09:32 GMT

Hi Lech,

I checked my versions it is 18.0.4 - February 2018 SR1.

Re: Qlik Nprinting Levels

Ruggero_Piccoli — Wed, 25 Jul 2018 08:24:21 GMT

Hi,

I suggest you to update to latest available version June 2018 and test the same report with it.

Best Regards,

Ruggero

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

Re: Qlik Nprinting Levels

Lech_Miszkiewicz — Wed, 25 Jul 2018 11:56:47 GMT

quck note on this - just before you upgrade Qlik Sense to June version double check if you use anywhere in your applications extensions as they will likely stop working

regards

Lech

Re: Qlik Nprinting Levels

KasperJeppesen1 — Tue, 26 Jan 2021 12:53:33 GMT

Hi @Ruggero_Piccoli

I am about to use N-printing and just saw your comment.

I have a pivot table and normal tables, where I need to use levels on ID's (ID is users). Is it still the case, that you cannot add levels to pivot-tables and tables in Qlik Sense N-printing ?

I simple have a pivot-table and a filter-pane for my ID's (ID is users), and needed a PDF with my pivot-table, but with one for each ID.

Thank you!

Re: Qlik Nprinting Levels

Ruggero_Piccoli — Wed, 27 Jan 2021 08:35:09 GMT

Hi,

You cannot insert native Excel pivot tables inside levels.

You can insert native QlikView or Qlik Sense pivot tables inside Levels.

Best Regards,

Ruggero

Re: Qlik Nprinting Levels

KasperJeppesen1 — Mon, 22 Feb 2021 10:11:34 GMT

Hi @Ruggero_Piccoli

Hope it is okay to reply here again. I have a question more.

I have had some troubles with filters and pixel perfect reports. Is it possible to apply filters the same way in pixel perfect reports, as with excel reports, and apply together with levels? I need to filter on some cities, and still use my levels.

Thank you!

Re: Qlik Nprinting Levels

Lech_Miszkiewicz — Mon, 22 Feb 2021 10:11:41 GMT

Hi @KasperJeppesen1

This is different type of question so next time start new thread...

The answer to your question is NO! - object filters are only available in MS Office based templates. and not in Pixel Perfect

cheers

Re: Qlik Nprinting Levels

KasperJeppesen1 — Mon, 22 Feb 2021 15:03:45 GMT

@Lech_Miszkiewicz , @Ruggero_Piccoli

Thank you for your answer. I tried to create a new questions for what I am about to ask, but it was not possible to click the "Post". I hope it is okay, I am posting here! Sorry!

__________________

I have had some troubles with the following. I have 3 sections in my nprinting report, where I use levels and pages to separate by ID. Meaning, for each ID, I have 3 sections that should appear after eachother on their own page in a level cycle.

But, I have not been able to solve this. I have tried to put the sections in their own sheet, and added the level-id and page-id. But then it is just showing all the sections 1, then all sections 2 and then all sections 3.

I tried to work in just 1 sheets, where the sections comes after each other but does not appear on their own sheet and are very messy.

Can you help? I simply just need the report, to have each section starting on their own sheet and stay in the cycle, with section 1, 2 and 3 coming after eachother based on ID. I am using excel, as I need to use filters.

I am using:

Qlik NPrinting November 2019

Version: 19.40.3.0

Thank you!

Re: Qlik Nprinting Levels

Ruggero_Piccoli — Mon, 22 Feb 2021 15:24:26 GMT

Hi,

It is quite hard to understand where the error could be without seeing the template.

You have to use the Pages node to create the Excel worksheets. So add the field you want to use to create the worksheets in that node. The content of each single worksheet will be filtered by the specific value for the sheet is created.

Then add the ID into the Levels node and create the level in the template. You can combine Levels and Pages in the same worksheet of a template.

In both cases, levels and pages, you will have a level or page ofr each distinct value of the used fileds.

Best Regards,

Ruggero