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?
