remove the Row with Zero Quantity

[suhascool1]

Hi,

i have data loaded in the qlik which is Table 1.

so i want to remove the row which is zero in the Confirm Quantity. 

please suggest 

Tabel 1

Order Number	Schedule Line Number	Material_Code	Material Name	Confirm Qty
1234	2	10C39	Wooden Box	2
1234	1	10C39	Wooden Box	0
3456	2	39C34	Glass	1
3456	1	39C34	Glass	0
9805	2	56C34	Cotton	5
9805	1	56C34	Cotton	0

Final table like this 

Order Number	Schedule Line Number	Material_Code	Material Name	Confirm Qty
1234	2	10C39	Wooden Box	2
3456	2	39C34	Glass	1
9805	2	56C34	Cotton	5

[theoat · Accepted solution]

You can do this when loading data by adding the clause where Confirm Qty <> 0, or with a set analysis in a measure of your table {<[Confirm Qty] -= {"0"}>}.

Kind regards,
Théo ATRAGIE.

[suhascool1]

Thank you

[theoat]

You welcome, 
Have a nice day.