how to exclude values with conditions!

[#1]

Hello every one ,

Every day I learn a new thing in Qlikview ; today I have to exclude values from a tables with condition.

When "Product_Field"=value then  exclude the product .

When I have CA=0 , I want to exclude the product from the table . like this screenshot:

[Anonymous]

HI

I have weeks showing as 201705 on a chart until 201728

I need to exclude 201728 so it shows until 201727

Plz help if you don't mind

Thnx so much