Please help in solving the below scenario while using Levels in NPrinting excel template:-
We have a requirement where users want the tables in the horizontal side by side view for the
values of the field being used in Levels of of the excel template.
For ex: if a user has selected something from the Level 1 field, then the corresponding Level 2 which is used in the Levels of the excel template should be
displayed horizontally as side by side view for all the values of Level 2 corresponding to Level 1.
Levels in Excel templates (and also in all other types of templates) work only in vertical mode.
To create many tables side-by-side in horizontal way you could add the source table many times in the tables node and apply an object filter to each one. In this case also empty tables will be displayed.
Qlik NPrinting Excel templates support also Excel macros, so you could evaluate to create a vertical report with levels and develop a macro that transforms it into a horizontal one. Please note that macros are never executed, only copied, by Qlik NPrinting so the recipients have to run the macro by themself or you can associate it with the opening event.
Best Regards,
Ruggero
Best Regards, Ruggero --------------------------------------------- When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Levels in Excel templates (and also in all other types of templates) work only in vertical mode.
To create many tables side-by-side in horizontal way you could add the source table many times in the tables node and apply an object filter to each one. In this case also empty tables will be displayed.
Qlik NPrinting Excel templates support also Excel macros, so you could evaluate to create a vertical report with levels and develop a macro that transforms it into a horizontal one. Please note that macros are never executed, only copied, by Qlik NPrinting so the recipients have to run the macro by themself or you can associate it with the opening event.
Best Regards,
Ruggero
Best Regards, Ruggero --------------------------------------------- When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
