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.
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.
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.