topic Macro for supressing zeros in QlikView

Macro for supressing zeros

devans_1 — Wed, 22 Feb 2012 12:39:04 GMT

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

Macro for supressing zeros

CELAMBARASAN — Wed, 22 Feb 2012 12:42:56 GMT

Hi,

It should be

fprop.SuppressZero = True

Celambarasan

Macro for supressing zeros

Wed, 22 Feb 2012 13:01:59 GMT

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.

Macro for supressing zeros

Wed, 22 Feb 2012 13:16:05 GMT

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

Macro for supressing zeros

devans_1 — Wed, 22 Feb 2012 13:42:26 GMT

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 ?