What is the function of levels in Nprinting?

[#1]

Hi,All

What is the function of levels in Nprinting?

Thankyou

[danieloberbilli · Accepted solution]

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.

   

[#3]

Thankyou for your correct reply

[stevedark]

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

[vireshkolagimat]

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

[stevedark]

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

[vireshkolagimat]

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

[stevedark]

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

[vireshkolagimat]

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.

[stevedark]

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