Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

alex_stone
Contributor

How to hide empty columns for NPrinting

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 2017Jun 2017Jul 2017...
112233
112233
112233

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

Tags (1)
3 Replies
devarasu07
Honored Contributor II

Re: How to hide empty columns for NPrinting

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
Contributor

Re: How to hide empty columns for NPrinting

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
Contributor

Re: How to hide empty columns for NPrinting

Where can I get the help?

Community Browser