Levels in NPrining excel template

achhura01 — Mon, 03 Feb 2020 12:15:21 GMT

Hi All,

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.

Re: Levels in NPrining excel template

Ruggero_Piccoli — Mon, 03 Feb 2020 13:25:46 GMT

Hi,

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

topic Re: Levels in NPrining excel template in Qlik NPrinting

Levels in NPrining excel template

Re: Levels in NPrining excel template