With my current requirement, I am asking Qlikview to show all product values and populate missing values with a '0'. However when I export to excel, the populated 0 values are formatted as text when I need them to be formatted as a number! The object I am exporting is a pivot table. Is there any work around for this? Thanks!
Things I have tried.
- num function around the expression
- using the number tab
- trying to trick excel by right aligning any text on the presentation tab
My feeling is Qlikview is programmed to populate missing cells with only text values rather than numeric.