how to remove 0 on column.

[#1]

Good Day Qlikcommunity,

I want to remove all who has 0 penalty in the table.

Any advice and tips? Please see Attachment

Thanks in advance

[settu_periasamy]

Hi,

find the below snapshot. Presentation Tab -> Suppress Zero

[#3]

In what dimension sir? How can I use "Surpress when value is zero" in expression by the way? I'm a bit confuse right now

[settu_periasamy]

It is not dimension based. In the Presentation Tab, Check the "Suppress Zero-Value".

This will apply for all.

Try the below screen shot.

[#5]

sir what happened is the owner who has a value of '-' got replace with '0'

[qlikviewwizard]

Hi imlesterrawr , This will work on database data also.

use penaltynew as shown in my reply screen. Or check the application.

[qlikviewwizard]

Which chart you are using? Tabular or Bar,Pivot,straight table... ?

[settu_periasamy · Accepted solution]

When you are using the "Suppress Zero value", and if you have the value '0' in the Penalty field, it wont display.

Edit: Uncheck the "Suppress Missing" on the same tab if you have null values

[#9]

Sir wizard,

I'm only using Straight Table. But is it possible in expression to remove all owner who has 0 and '-'(null?) value?

[#10]

Nothing happened sir
still the same, I already press the okay and apply but the 0 and '-' is still there

[settu_periasamy]

can you share the sample Qvw file?. it would be easier to find the solution.

Edit :

otherwise , try to use in the below expression.

if(not isnull(penalty) and penalty>0, penalty)