Removing dashes '-' from pivot table exports

dvickers — Fri, 23 Mar 2018 05:14:58 GMT

Does anyone know how to remove the '-' from a pivot table export in Excel? Below is an example.

Re: Removing dashes '-' from pivot table exports

aworrall — Wed, 19 Feb 2020 19:11:35 GMT

Hi, I've not found a way in Qlik Sense yet but in excel it's easily removed.

Ctrl + F, for the 'find and replace' dialog. Inset the dash into the 'Find what' field.

Click 'Option's and tick the box next to 'Match entire cell contents'

Click the 'Replace' tab and don't type anything in.

Hit the 'Replace All' button.

It will then remove the dashes from the spreadsheet without effecting any negative values you have exported