Remove 0 from table into script

pgalvezt — Tue, 13 Feb 2018 20:16:26 GMT

Hello,

I have a table with 3 fields with many values they all has '0', what I want is remove them but filtered, because if i remove a 0 value the other field maybe can a value <> to 0,

So I need filtered all 0 in 3 fields and the remove them all this into the script.

I prepared an excel file for better comprehenssion,

Lines 2 - 6 - 9 were removed...

Thanks!

Re: Remove 0 from table into script

el_aprendiz111 — Tue, 13 Feb 2018 20:57:17 GMT

Hi,

tmp:
LOAD id,
[money 1],
[money 2],
[money 3]
FROM
[..\..\Documents\Downloads\Example (1).xlsx]
(ooxml, embedded labels, table is [Table in script])

Where RangeSum([money 1],[money 2],[money 3])>0
;

topic Re: Remove 0 from table into script in QlikView

Remove 0 from table into script

Re: Remove 0 from table into script