topic Hide Column from Table in NPrinting Excel Report in Qlik NPrinting

Hide Column from Table in NPrinting Excel Report

profilejamesbond — Thu, 27 Jun 2024 12:41:46 GMT

Hi,

I have one table in QlikView Dashboard that contains column1, column2, column3, ..., columnN.

Now, I created NPrinting Report where I added this table from the QlikView Dashboard based on Object ID.

My requirement is to hide column2, and column3 from NPrinting final view. So, when I'll send the report I don't want to send the column2, and column3. But I want these columns in QlikView Dashboard table.

How to Hide these columns in NPrinting?

I am using NPrinting May 2023

Thanks

Re: Hide Column from Table in NPrinting Excel Report

Lech_Miszkiewicz — Thu, 27 Jun 2024 13:18:22 GMT

Hi @profilejamesbond

since you are adding this as whole object id you may need to create conditional hide for those columns in qlikview based on variable.
That variable should make columns visible in QlikView but in Nprinting you could create a filter which would change variable and hide columns. You then apply that filter to report in Nprinting. Thats the easiest and quickest solution.

Alternative would be to create duplicated object without columns you dont need and use that duplicated object.

Lastly-you could bring individual columns tags in Nprinting (instead of whole object id). That would only work if table is a straight table and only of there is no conditional hide/show on any column.

cheers

Re: Hide Column from Table in NPrinting Excel Report

profilejamesbond — Fri, 28 Jun 2024 07:26:32 GMT

Hi @Lech_Miszkiewicz,

Yes, I added columns in the report.

First Add Table in the NPrinting and then drag and drop only required columns in the excel based NPrinting report. In this way, I only added required fields in the report.

Thanks

Re: Hide Column from Table in NPrinting Excel Report

Lech_Miszkiewicz — Fri, 28 Jun 2024 11:32:29 GMT

Hi @profilejamesbond

funny you marked your answer as solution given that earlier I have provided you with 3 possible answers and you actually used one of them 😄

Lastly-you could bring individual columns tags in Nprinting (instead of whole object id). That would only work if table is a straight table and only of there is no conditional hide/show on any column.

anyway 😄