topic Re: What is the function of levels in Nprinting? in Qlik NPrinting

What is the function of levels in Nprinting?

Wed, 25 Sep 2019 18:40:54 GMT

Hi,All

What is the function of levels in Nprinting?

Thankyou

Re: What is the function of levels in Nprinting?

danieloberbilli — Tue, 05 May 2015 02:16:21 GMT

In an Excel report you can set levels where you can loop across certain dimensions e.g. Product Category A,B,C

You mark the start row and end row of the level. These rows will then be looped/continued on the rows below.

So if you have a graph or a table as content, it will be shown 3 times...for A, B, C underneath each other.

Its similar to 'Pages' when doing a PowerPoint-Report.The 'Pages' in PowerPoint would do the same but with the whole ppt-sheet.

Re: What is the function of levels in Nprinting?

Tue, 05 May 2015 02:25:22 GMT

Thankyou for your correct reply

Re: What is the function of levels in Nprinting?

stevedark — Tue, 05 May 2015 05:59:22 GMT

It's worth noting that Pages are also available to you in Excel, creating new sheets for each distinct value in a QlikView field. Also, that Levels can be nested, so NPrinting will enumerate around combinations of field values. Levels can also be used in other report types, and not just Excel.

Steve

Re: What is the function of levels in Nprinting?

vireshkolagimat — Thu, 07 Jul 2016 09:05:56 GMT

Hi Steve,

I have some hierarchical data in excel and using the excel source i have created straight table. How to represent this hierarchical data in Word Template using level. Is there any other way to represent this data. The data looks like below.

Header

ABC

EFH

LMN

XYZ

PQR

CCA

Regards,

Viresh

Re: What is the function of levels in Nprinting?

stevedark — Thu, 07 Jul 2016 09:58:33 GMT

Does the data appear in column A and column B in Excel? If so, you want to use a Fill transformation and a WHERE to bring the data into QlikView, populating the missing cells.

If it is a true hierarchy then you will want to use a hierarchy load in the load script.

Both of these things you should be able to find information on if you Google for it.

Once you have the data looking like this:

Field1,Field2

ABC,EFH

ABC,LMN

XYZ,-

PQR,CCA

Then you can simply use a band in NPrinting on Field1 and then list Field2 within it.

Steve

Re: What is the function of levels in Nprinting?

vireshkolagimat — Thu, 07 Jul 2016 10:05:33 GMT

all the data lies in one column and hierarchy is indented with the column like i shown above.

Re: What is the function of levels in Nprinting?

stevedark — Thu, 07 Jul 2016 10:28:06 GMT

That's not pretty data to have to deal with. To get the two columns you will need to do a bit of fiddling on the load, it will be something like:

LOAD

WHERE not IsNull(Field2)

;

LOAD

Header,

if(left(Header, 2) <> ' ', Header, PEEK(Field1, -1)) as Field1,

if(left(Header, 2) = ' ', mid(Header, 1, 2), null()) as Field2

FROM ...

I've not tested this, so it may need some tweaking, but it should point you in the right direction.

Steve

Re: What is the function of levels in Nprinting?

vireshkolagimat — Thu, 07 Jul 2016 11:07:07 GMT

Actually i brought the data into qlikview as is in excel. Now i want to show that hierarchical information in nPrinting word Template. Currently if drag that header column it is showing one single column without hierarchy.

Re: What is the function of levels in Nprinting?

stevedark — Thu, 07 Jul 2016 11:14:04 GMT

That is because just having a couple of spaces at the start of the field does not make it a hierarchy. You will need to manipulate the data into two columns in the load script. I believe the code that I put should do this for you.

Steve

Re: What is the function of levels in Nprinting?

vvkranawat — Wed, 10 Apr 2019 08:32:22 GMT

Hi,

Can i use level function in the NPriting report 2 times.

For EG: First i want sales report as total Country wise and than total region wise.

Thanks

Re: What is the function of levels in Nprinting?

Frank_S — Wed, 10 Apr 2019 13:59:57 GMT

Have a look at the explanation here from my colleague @Ruggero_Piccoli

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-difference-between-Level-and-Page/m-p/1418554?et=watches.email.outcome#1367794

Here is a video demonstration as well

https://www.youtube.com/watch?v=HjIK7cC9HJk

Hope this helps...