Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

vandrieg
New Contributor III

null values in Pivot tables

To avoid null values in Pivot tables, in the presentation tab I indicated 0 for Null symbol and missing symbol.

When the table is exported to excel, the cells with 0 are considered text format.

Is there a way to make them export as numeric format?

1 Reply

Re: null values in Pivot tables

Hi,

Instead of that solution I would suggest you to handle null in script.

Attached document will help you in doing that.

Let me know if that worked.

Regards

ASHFAQ

Community Browser