Excluding values from table

[rassanbekov]

Hello!

In straight I need to show only those value which have "zero" in cells. For example,

Header 1	Header 2	Header 3	Header 4
A	10	0	12
B	20	0	0
C	30	20	11
D	40	10	0
E	50	0	0

As a result of formula, the table should transform to the following:

Header 1	Header 2	Header 3	Header 4
B	20	0	0
E	50	0	0

Kind regards,

Ruslan

[Anil_Babu_Samineni]

Why Can't this?

LOAD [Header 1],

     [Header 2],

     [Header 3],

     [Header 4]

FROM

[https://community.qlik.com/message/1284642]

(html, codepage is 1252, embedded labels, table is @1) Where  Match([Header 3], 0) and Match([Header 4], 0);