0 Replies Latest reply: Nov 18, 2011 11:29 AM by Marc Livingston RSS

    Set missing values to 0, export as number

      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?