topic Set missing values to 0, export as number in QlikView https://community.qlik.com/t5/QlikView/Set-missing-values-to-0-export-as-number/m-p/329183#M1183940 <HTML><HEAD></HEAD><BODY><P>I am sure someone else has asked for this but I am not what to search for.</P><P></P><P>I have a pivot table where some of the results are missing. I change the settings to display a 0 instead of -. When I export this to excel I would like the missing values to export as a 0 but it is seeing it as a string. How can I tell Qlikview that missing values should be the number 0 and not a string?</P></BODY></HTML> Fri, 18 Nov 2011 16:29:43 GMT 2011-11-18T16:29:43Z Set missing values to 0, export as number https://community.qlik.com/t5/QlikView/Set-missing-values-to-0-export-as-number/m-p/329183#M1183940 <HTML><HEAD></HEAD><BODY><P>I am sure someone else has asked for this but I am not what to search for.</P><P></P><P>I have a pivot table where some of the results are missing. I change the settings to display a 0 instead of -. When I export this to excel I would like the missing values to export as a 0 but it is seeing it as a string. How can I tell Qlikview that missing values should be the number 0 and not a string?</P></BODY></HTML> Fri, 18 Nov 2011 16:29:43 GMT https://community.qlik.com/t5/QlikView/Set-missing-values-to-0-export-as-number/m-p/329183#M1183940 2011-11-18T16:29:43Z