Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
Regards,
Deva
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.
Where can I get the help?