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

[sinanozdemir]

Hi Lester,

If you want to remove it in the load script, then please see the below screenshot:

[settu_periasamy]

Hi,

what is your expressions? if the penalty is the only expression, then check the "Suppress When value is Null" for your all dimensions.

[Chanty4u]

Hi

PFA,

if u want use dat dimension in chart do like dis or go through wit attached .qvw

Thank you

Suresh

[#5]

Sir I only need to remove the owner who has 0 penalty on this table only. What if I need penalty with 0 on the later part?

[qlikviewwizard]

Hi Use this script:

CH02_20150703_094758:

LOAD year1,

    qtr1,

    RPUNum,

    owner,

    [Owner Pin],

    address,

    penalty,

    if(penalty<> 0,1,0) as penaltynew

FROM

CH02_20150703_094758.xls

(biff, embedded labels, table is Sheet1$);

Use list box on penaltynew column.

select value '1' from penaltynew and select the options as shown in screen.

[#7]

Sir I only use penalty on expression, I dont know yet how to remove those owner who's penalty is 0 and display owner who has penalty only.

[Chanty4u]

hi

u can use condition like

Where Dimension<>0;

Thank you

Suresh

[sinanozdemir]

Then you can use "Surpress when value is zero" in expression tab.

[#10]

Hi qlikview wizard,

Is there other way? I load it on a Database not in Excel actually.
Can you make remove the 0 using expression?