Macro for supressing zeros

[devans_1]

Does anybody know the macro syntax for suppressing zeros in a table ? I need to be able to toggle between showing zeros and not showing them. I tried the code

sub Suppress_Zero_Values  
set obj = ActiveDocument.GetSheetObject("CH109")
set fprop = obj.GetProperties
fprop.ZeroSuppression = True
end sub

but something is wrong with fprop.ZeroSuppression

[CELAMBARASAN · Accepted solution]

Hi,

     It should be

     fprop.SuppressZero = True

Celambarasan

[#3]

Hi, You have Suppress Zero option available in Presentation Tab or you can use aggr() function in Dimension like =if(aggr(sum(something), dimension) <> 0, dimension) then use Suppress when value is null in dimension tab.

[#4]

You have to call obj.SetProperties fprop after having changed the properties object.


[devans_1]

Thanks. This was exactly what I needed. And I do need to call obj.SetProperties afterwards.

Does anyone know if there is a document anywhere that links all the Qlikview descriptions (like Suppress Zero Values' to 'SupressZero') to the macro calls ?