Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
ashfaq_haseeb
Champion III
Champion III

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