Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know how to remove the '-' from a pivot table export in Excel? Below is an example.
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