Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
jacek_k
Contributor III
Contributor III

How to remove "-" from export excel file

Hello, I made simple pivot table, sometimes data is missing and qlik add "-" sign inside cells.

How to remove "-" from pivot table? I want blank cell when user export to excel file.

Labels (2)
1 Reply
Or
MVP
MVP

If there's an actual combination of values which returns null, you can replace it with a blank string '' using:

Coalesce(YourFormula,'')

However, it is not possible to remove the nulls from pivot table intersections where no combination of dimensions exist, so if that's your situation you'll need to either add all of the possible intersections in your data load, or live with the nulls.

Note that certain third-party solutions, such as Vizlib Pivot Table, may also allow you to achieve what you want. In the case of Vizlib's pivot table, you can set your own Null values rather than having the default dash.