topic null values in Pivot tables in QlikView https://community.qlik.com/t5/QlikView/null-values-in-Pivot-tables/m-p/701440#M1318265 <HTML><HEAD></HEAD><BODY><P>To avoid null values in Pivot tables, in the presentation tab I indicated 0 for Null symbol and missing symbol.</P><P>When the table is exported to excel, the cells with 0 are considered text format.</P><P>Is there a way to make them export as numeric format?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT Anonymous 2026-01-26T18:19:17Z null values in Pivot tables https://community.qlik.com/t5/QlikView/null-values-in-Pivot-tables/m-p/701440#M1318265 <HTML><HEAD></HEAD><BODY><P>To avoid null values in Pivot tables, in the presentation tab I indicated 0 for Null symbol and missing symbol.</P><P>When the table is exported to excel, the cells with 0 are considered text format.</P><P>Is there a way to make them export as numeric format?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/null-values-in-Pivot-tables/m-p/701440#M1318265 Anonymous 2026-01-26T18:19:17Z Re: null values in Pivot tables https://community.qlik.com/t5/QlikView/null-values-in-Pivot-tables/m-p/701441#M1318269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Instead of that solution I would suggest you to handle null in script.</P><P>Attached document will help you in doing that.</P><P></P><P>Let me know if that worked.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 04 Sep 2014 07:51:35 GMT https://community.qlik.com/t5/QlikView/null-values-in-Pivot-tables/m-p/701441#M1318269 ashfaq_haseeb 2014-09-04T07:51:35Z