Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

Dynamic excel sheet with Predefined Formatting in NPrinting 17.2

Hi,

I have the following requirement. I have 9 Categories and 10-20 subcategories in each of them.

1. I need to create one sheet with tables for each category.

category.PNG

2. I need to create sheets for 4 fixed categories, with tables for their sub categories. And another sheet with remaining categories.

Cat1.PNG

For these I have the above  format.

I have tried using Levels, however this hampers formatting.

Overall I have near about 100 tables.  I can make the report, if can create all the tables hard-coded using set analysis.

Even this does not keep the source template format. I have to format the tables manually. Moreover for any addition or change in category/Subcategory I would have to modify tables in App. 

Is there a way to create these tables dynamically keeping formats?

2 Replies
Employee
Employee

Re: Dynamic excel sheet with Predefined Formatting in NPrinting 17.2

If you uncheck "Keep source formatting" from the table properties in NPrinting before you drag-and-drop into the template, the template source formatting should be preserved.

Not applicable

Re: Dynamic excel sheet with Predefined Formatting in NPrinting 17.2

I have tried that. But could not keep the format.

Community Browser