Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Lester,
If you want to remove it in the load script, then please see the below screenshot:
Hi,
what is your expressions? if the penalty is the only expression, then check the "Suppress When value is Null" for your all dimensions.
Hi
PFA,
if u want use dat dimension in chart do like dis or go through wit attached .qvw
Thank you
Suresh
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?
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.
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.
hi
u can use condition like
Where Dimension<>0;
Thank you
Suresh
Then you can use "Surpress when value is zero" in expression tab.
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?