topic Re: Hide Columns in NPrinting Excel Template in Qlik NPrinting

Hide Columns in NPrinting Excel Template

EISSA — Tue, 14 Jun 2022 08:39:19 GMT

Hello,

Is there a way to hide columns in an NPrinting Excel Template?

I know that the columns can be conditionally hidden in the source Qlik Sense chart, but I need to control it from Nprinting Template.

Any suggestions how this can be done in NPrinting?

Re: Hide Columns in NPrinting Excel Template

aeveltstra — Tue, 14 Jun 2022 16:35:20 GMT

It depends on how you display the chart.

If you drop the entire chart into the template, and have it expand its range, then the template cannot hide or show columns inside of that range. You would need the chart to hide dimensions conditionally, in the Qlik document, but conditionals are not supported in NPrinting.

If, instead, you drop individual columns from the chart into the template, then you can use regular Excel formatting to hide a column. In order to do it based on conditions, I fear using a macro is your only option. But you can make the text appear invisible by using conditional formatting to change the text color to match the cell background color.

Re: Hide Columns in NPrinting Excel Template

EISSA — Wed, 15 Jun 2022 06:55:12 GMT

@aeveltstra thanks for your reply.

In my case I am talking about hiding columns from a table in Excel Nprinting table.

by any chance do you know if I can use an if condition based on a variable sent to the excel template in the conditional formatting to hide the column or the conditional formatting works only based on the result in the field itself ?

can you please send me more details how to solve it using the conditional formatting thing ?

thanks.

Re: Hide Columns in NPrinting Excel Template

Lech_Miszkiewicz — Wed, 15 Jun 2022 11:55:47 GMT

Hi @EISSA

As @aeveltstra said you cannot control if column is entered into template from NPrinting side, or whether column is hidden or deleted. Instead you can use:

excel macro to delete column based on parameter added to template
- note that this will only work if macro is executed after document is opened by user
you can have qlik sense/qlikview formula which conditionally returns no values in column which needs to be hidden. In reality column is still there but empty. Same can apply to its label which can be done by use of nprinting formula
- If(vHide=1, "", measure expression)