Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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?