Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,All
What is the function of levels in Nprinting?
Thankyou
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.
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.
Thankyou for your correct reply
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
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
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
all the data lies in one column and hierarchy is indented with the column like i shown above.
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
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.
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