topic Re: how to remove 0 on column. in QlikView

how to remove 0 on column.

Fri, 03 Jul 2015 01:54:14 GMT

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

Re: how to remove 0 on column.

sinanozdemir — Fri, 03 Jul 2015 02:11:53 GMT

Hi Lester,

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

Re: how to remove 0 on column.

settu_periasamy — Fri, 03 Jul 2015 02:14:46 GMT

Hi,

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

Re: how to remove 0 on column.

Chanty4u — Fri, 03 Jul 2015 02:33:47 GMT

PFA,

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

Thank you

Suresh

Re: how to remove 0 on column.

Fri, 03 Jul 2015 02:34:01 GMT

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?

Re: how to remove 0 on column.

qlikviewwizard — Fri, 03 Jul 2015 02:35:16 GMT

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.

Re: how to remove 0 on column.

Fri, 03 Jul 2015 02:35:21 GMT

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.

Re: how to remove 0 on column.

Chanty4u — Fri, 03 Jul 2015 02:36:05 GMT

u can use condition like

Where Dimension<>0;

Thank you

Suresh

Re: how to remove 0 on column.

sinanozdemir — Fri, 03 Jul 2015 02:43:58 GMT

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

Re: how to remove 0 on column.

Fri, 03 Jul 2015 02:49:11 GMT

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?

Re: how to remove 0 on column.

settu_periasamy — Fri, 03 Jul 2015 02:49:15 GMT

Hi,

find the below snapshot. Presentation Tab -> Suppress Zero

Re: how to remove 0 on column.

Fri, 03 Jul 2015 02:51:19 GMT

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

Re: how to remove 0 on column.

settu_periasamy — Fri, 03 Jul 2015 02:56:15 GMT

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

This will apply for all.

Try the below screen shot.

Re: how to remove 0 on column.

Fri, 03 Jul 2015 02:57:15 GMT

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

Re: how to remove 0 on column.

qlikviewwizard — Fri, 03 Jul 2015 02:57:53 GMT

Hi imlesterrawr , This will work on database data also.

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

Re: how to remove 0 on column.

qlikviewwizard — Fri, 03 Jul 2015 02:59:42 GMT

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

Re: how to remove 0 on column.

settu_periasamy — Fri, 03 Jul 2015 03:02:54 GMT

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

Re: how to remove 0 on column.

Fri, 03 Jul 2015 03:04:30 GMT

Sir wizard,

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

Re: how to remove 0 on column.

Fri, 03 Jul 2015 03:07:08 GMT

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

Re: how to remove 0 on column.

settu_periasamy — Fri, 03 Jul 2015 03:09:50 GMT

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)