Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jcramirez472
Partner - Contributor III
Partner - Contributor III

EXPORT XLS FORMATTED AS TEXT IN QLIKVIEW RATHER THAN NUMBER

Hi all,

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.

0 Replies