remove '0'

[vardhan1305]

I have a straight table and i need to remove 0 from it.

ID           Customer            Value              parttotal

1                 a                        5                          12

2                   -                        0                    123

2                  b                        6                      155

3                  c                        4                        100

4                 d                         5                    121

4                  -                         0                         222

5                    -                        0                       111

o/p:

ID           Customer            Value              parttotal

1                 a                        5                          12

2                  b                        6                      155

3                  c                        4                        100

4                 d                         5                    121

Please help me out.

[jyothish8807]

Try like this:

Dimension:

if (aggr(Sum(Value),ID,Customer)>0, ID)

Also click suppress null value for ID

Br,

KC

[Anonymous]

May be like this:

1. In Value Dimension:

=If(Value > 0 , Value)

2. Or at back-end script you can try this

Data:

Load * Inline [

ID,Customer,Value,parttotal

1,a,5,12

2,-,0,123

2,b,6,155

3,c,4,100

4,d,5,121

4,-,0,222

5,-,0,111

]

where Value >0;

Thanks and regards,

Yogendra W. ! !

[qlikviewwizard · Accepted solution]

Hi,

Try like this:

[vardhan1305]

It worked arjun but sorry i forgot to include another scenario where there are negative values too.

ID           Customer            Value              parttotal

1                 a                        5                          12

2                   -                        0                    123

2                  b                       - 6                      155

3                  c                        4                        100

4                 d                        - 5                    121

4                  -                         0                         222

5                    -                        0                       111

O/p:

o/p:

ID           Customer            Value              parttotal

1                 a                        5                          12

2                  b                        -6                      155

3                  c                        4                        100

4                 d                         -5                    121

What to do in this scenario.

[vardhan1305]

It worked but sorry i forgot to include another scenario where there are negative values too.

ID           Customer            Value              parttotal

1                 a                        5                          12

2                   -                        0                    123

2                  b                       - 6                      155

3                  c                        4                        100

4                 d                        - 5                    121

4                  -                         0                         222

5                    -                        0                       111

O/p:

o/p:

ID           Customer            Value              parttotal

1                 a                        5                          12

2                  b                        -6                      155

3                  c                        4                        100

4                 d                         -5                    121

What to do in this scenario.

[vardhan1305]

got it <>0. thanks for the help

[vardhan1305]

got it <>0. thanks for the help