Excluding values based on date in multiple sheet objects but not all

[Qlik_vic]

Hi,

I am new to qlik and I am wondering if there is a smarter way to exclude certain values based on date. I have a document with a lot of sheet objects and reports that I should remove certain products from, I should however not remove them from all sheet objects.

Currently I am using an if statement with set statement , i.e. if( year >=2019, sum({<$(vSetExcludeItems)>} SalesQty), sum(SalesQty))

This a simplified statement, but just to show what I mean. There is more than 20 sheet objects that I need to exclude it from, and in each object in all expressions. All the expressions differ so I can not just do a copy paste.

Is there any better way to do this? I am also wondering how much it will affect performance to have if statements in the majority of the expressions?

[ashok_rajm]

Hi,
Do you want to exclude dynamically or static. And what values you have in $(vSetExcludeItems).

[Qlik_vic]

The values are static.