Suppress zeros in query veiw

[Former Member]

Hi,

I need to suppress zeros in query view, but don't know how. I suppress zeros in related query, but when I create query view from this query zeros are displayed.

Thanks for any help

Regards Pavel

[Former Member · Accepted solution]

Hi Pavel,

Just right click on the column -> all characteristics -> suppress zero columns/rows.

Hope it helps.

Regards,

Ravi

[Former Member]

Hello Pavel,

if you are referring to workbook on that query, right click for the context menu, all characteritics-> suppress zero values.

do this in the workbook output when executed, then use option save as existing workbook.

next time when u execute the same, the values should be supressed.

hope it helps...

thanks

[Former Member]

Zeros were already suppressed, so it was not the point. I defined the query views once again and it helped.

Thanks a lot anyway.

Regads,

Pavel