I don't think you can automatically hide columns which have 0 in all rows in a Qlik Sense pivot table. Maybe if you would use a ValueList() function in a calculated dimension that would use Aggr() to check each row for a 0, but that would be a very unsustainable solution.
If you really need to have the table adjustable, I suggest you let the user to define which measures will be shown. This can be achieved either by utilizing variables along with the qsVariable extension, or using the Custom Report extension, which you can find on the Qlik Branch.
There is no 'out of the box' way to hide columns in Qlik Sense. It would be a good ting to put in as a feature request though, as it is something that is just a tick box in QlikView.
You may want to look at an extension that gives you table functionality and more configuration options, such as the VizLib table ( Vizlib | Blog ) . If you have any questions on whether this would be a good fit for you mahlerma is the man.
Hope that helps,