topic How to hide empty columns for NPrinting in Qlik NPrinting

How to hide empty columns for NPrinting

alex_stone — Wed, 20 Dec 2017 01:57:44 GMT

Currently, I have a excel report get data from QV dashboard's straight table. but this table will show the data based on fiscal year till now.

e.g. current month is Jun 2017, and then Jul 2017 columns is empty.

Apr 2017	May 2017	Jun 2017
11	22	33
11	22	33
11	22	33

We have use excel macro script to hide the empty columns when this Excel workbook open. But now we want to send this report as PDF format to user. It will show the empty column Jul 2017 and others always. The problem is how to hide the empty columns when convert the excel report into PDF format? Thanks

Re: How to hide empty columns for NPrinting

devarasu07 — Wed, 20 Dec 2017 03:38:10 GMT

Hi,

Yes, you limit from qlik side or Nprint side by using conditions (i.e using this method report will generate when it meet the condition so u can define rule like

=if(sum(Sales)>0,1,0) // QV side

create condition rule like below

sum(Sales)>0 // How to Control Report Generation with Conditions

Hope this helps to you

also check this article,

Conditions ‒ Qlik NPrinting

Regards,
Deva

Re: How to hide empty columns for NPrinting

alex_stone — Wed, 20 Dec 2017 04:09:04 GMT

Hi Devarasu R, thank you for your reply.

we have hid the columns in QV side. But for NPrinting excel report we should add all columns no matter it's empty or not.

We can use VBA script to hide the empty columns for excel report. But now we need stored as PDF format for the excel report. The PDF report will include empty columns. How to remove these empty columns in PDF file.

Re: How to hide empty columns for NPrinting

alex_stone — Wed, 20 Dec 2017 16:47:04 GMT

Where can I get the help?