Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

How can I display zero columns in NPrinting ?

Hi All,

I have a QV dashboard from which I'm creating a NPrinting Excel report. The QV dashboard has a pivot table object for which the Show All Values option is checked on the Dimensions tab. This allows zero or null columns/rows to be displayed on the dashboard.

However, when I come to producing the Excel report in NPrinting, zero and null columns are removed and not displayed.

How can I force blank columns to be displayed in my NPrinting report ?

Thanks for your help in anticipation.

MV

2 Replies
harishkumarg
Contributor III

Re: How can I display zero columns in NPrinting ?

Hi,

I am able to display Zero columns as shown below,

Image.PNG

Please find the attached sample QVW, NSQ, Template, Excel Output for reference.

Regards

Harish

harishkumarg
Contributor III

Re: How can I display zero columns in NPrinting ?

The above solution worked for you?

Regards

Harish

Community Browser