Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

App Development

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Who Me Too'd this topic

heij1421
Partner - Creator
Partner - Creator

Export Excel : issue with null values

When exporting a pivot table to excel in Qlik Sense, the empty fields are exported with a '-' symbol.

When adding additional formulas to this excelsheet, like A1+B1 and this A1 field has a '-' value, excel returns #VALUE!.
(sum a1:b1 does work as a workaround). 

Is there a way to change this general dash symbol from '-' to an empty field. Preferable a general setting so I don't have to change all formulas?

 

Labels (1)
Who Me Too'd this topic