Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
It should be
fprop.SuppressZero = True
Celambarasan
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.
You have to call obj.SetProperties fprop
after having changed the properties object.
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 ?