Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.