How to hide empty columns for NPrinting

[alex_stone]

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	Jul 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

[devarasu07]

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

[alex_stone]

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.

[alex_stone]

Where can I get the help?