I am sure someone else has asked for this but I am not what to search for.
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?